EMS logo

Products Navigation

SQL Query for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for Oracle

On-line Documentation

Query Plan

Using SQL Query 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 the query in SQL Editor or Visual Query Builder and use the btnExplainQuery Explain Query button on the main toolbar, proceed to the Results tab, and then to the Plan tab there.


hs3340 - Query Plan


If you wish to make the Query Plan tab enabled by default for each executed query, select the Queries with explain plan option within the Preferences section of the Environment options dialog.


See also:

SQL Editor

Visual Query Builder

Query History