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.