Viewing the Estimated Query Execution Plan

SQL Query Analyzer Help

SQL Query Analyzer Help

Viewing the Estimated 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 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.