Getting Execution Plan

Execution Plan for SQL statements except stored procedures.

You can get execution plan for SQL statements, such as SQL SELECT without executing them on the server.

To get an execution plan for any SQL statement except stored procedure:

• Type the statement, you want to get an execution plan for, in the SQL Editor.
• Choose Execution Plan from the popup menu. The execution plan will be displayed in the separate tab at the bottom of the SQL Editor panel. If the Execution Plan Analyzer is not properly configured, the Configuration dialog box will be opened.

Execution Plan for stored procedures and views.

• Select required stored procedure or view in the Object Explorer.
• Choose Execution Plan from popup menu