SqlTalk 7.0.3 and Execution Plan

Discussion forum about all things Team Developer 7.x
gigit
Italy
Posts: 30
Joined: 14 Jun 2017, 15:04
Location: Italy

SqlTalk 7.0.3 and Execution Plan

Post by gigit » 24 May 2018, 08:34

Hi to all.
With SqlTalk 7.0.3 when I open Execution Plan window, this is what I see (see attachment).
Until v.6 it is normal.
In 7.0.0 was the same.
May I do something to repair it?
Thank you


------
Gigi
------
You do not have the required permissions to view the files attached to this post.

Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 84
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, U.K.

Re: SqlTalk 7.0.3 and Execution Plan

Post by Steve Leighton » 10 Nov 2019, 20:35

Ditto.

Use:
'Set planonly on'; or
'Set planonly off';

which work fine.
Greetings from New Zealand
Steve

Bankside Systems Ltd. ( UK ♦ Australia ♦ New Zealand )
www.banksidesystems.co.uk

Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 84
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, U.K.

Re: SqlTalk 7.0.3 and Execution Plan

Post by Steve Leighton » 10 Nov 2019, 21:26

Better still....

use Command Centre --> SQLTalk --> Execution Plan Tab. It changes dynamically.
SQLBase Command Centre - SQLTalk.JPG

or best of all, use Command Centre --> Process Statistics --> Watch Process --> View Execution plan. It also changes dynamically with each query, which can be a SQLTalk session outside of Command Center..
SQLBase Command Centre - Watch Process.JPG
You do not have the required permissions to view the files attached to this post.
Greetings from New Zealand
Steve

Bankside Systems Ltd. ( UK ♦ Australia ♦ New Zealand )
www.banksidesystems.co.uk

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests