Results 1 to 4 of 4

Thread: SQL 6.5 query execution plan .

  1. #1
    Join Date
    Sep 2002
    Location
    Germany
    Posts
    8

    Question 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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    In isql/w, go to query -> query options. You can enable query plan there.

  3. #3
    Join Date
    Sep 2002
    Location
    Germany
    Posts
    8

    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.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •