EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

Viewing query plan


Using SQL Manager for Oracle, 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 Query Builder and use the btnExplainQuery Explain query item of the Navigation bar.

 

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.

 

Query Builder - Viewing query plan

 

 

If necessary, you can specify that the Plan tab appears automatically upon query execution in Query Builder: select the CheckBox Explain query on execution option available within the Tools | Query Builder section of the Environment Options dialog.

 

 


See also:

Query execution