-
SQL 6.5 query execution plan .
Hello ,
I wanted to know whether we have an execution plan enabled in SQL 6.5 as we have it in SQL 7.0 and SQL 2000 .
I.e when we execute a query and if we enable ' show execution plan 'then it creates a map and shows the vital statistics .
If that is available on SQL 6.5 then i am missing that tool .
How can i have it installed on my SQL 6.5 server ??
Thanks.
-
In isql/w, go to query -> query options. You can enable query plan there.
-
SQL 6.5 query execution plan diagram.
Hello Rmiao,
Thanks for your reply . Will it also create a map for the execution description it provides in the results window ?
I tried through isql/w after i enabled the show plan option . But it provides only the text .
Is this possible in SQL 6.5 ? like we have it in SQL 7.0 and SQL 2000 where automatic query execution plan diagram is created when queries are executed .
Any info. in this regard .
Thanks once again.
-
I think that's what you can get in sql6.5.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|