Online Documentation for SQL Query for DB2

Query Plan


Using SQL Query for DB2, 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.