EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Viewing query plan


Using SQL Manager for SQL Server, you can view the plan for each of the queries created and executed in the application. The query plan is available within the corresponding Plan tab.

 

To view the Plan of a query, open the query in SQL Editor and use the btnExplainQuery Show estimated execution plan item of the Navigation bar or toolbar.

 

The Plan tab allows you to view the sequence of actions performed by the database server in the process of the query execution, and the amount of system resources used for the query execution.

 

SQL Editor - Viewing query plan

 

 

The Operation panel below displays the operations as a tree list with the following columns: Operation, Logical Operation, Subtree Cost, IO Cost, CPU Cost, Estimated Executions, Estimated Rows, Actual Executions, Actual Rows, Row Size, Parallel, Statement, Argument, Defined Values, Output, Warnings.

Right-click within the panel to display the context menu allowing you to configure the set of visible columns or export the plan to any of supported formats.

 

If necessary, you can specify that the Plan tab appears automatically upon query execution in SQL Editor: select the CheckBox Show actual execution plan on query execution option available within the Tools | SQL Editor section of the Environment Options dialog.

 

 


See also:

SQL Editor options

Executing queries