Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2000
Analyzing Queries
 Viewing the Query Execution Plan
SQL Query Analyzer Help (SQL Server 2000)
Viewing the Query Execution Plan
  1. If there is no query in the query pane, open a saved query or create a new query.

  2. On the Query menu, click Show Execution Plan or press CTRL+K to turn it on.

    Note  This option works only when connected to an instance of Microsoft® SQL Server™ version 7.0 or later.

  3. Execute the query by pressing F5, or on the Query menu, click Query Execute.

  4. Position the cursor over graphical elements to reveal additional execution plan information.
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker