Export (0) Print
Expand All

Viewing the Query Execution Plan

SQL Server 2000
  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.
© 2014 Microsoft