Online Documentation for SQL Query for Oracle

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.