Export (0) Print
Expand All

Viewing the Estimated 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 Display Estimated Execution Plan or press CTRL+L.

  3. If you have referenced temporary objects, no estimated query execution plan will be displayed.

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

  4. Position the cursor over graphical elements to reveal additional execution plan information.
© 2014 Microsoft