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 Explain Query button on the main toolbar, proceed to the Results tab, and then to the Plan tab there.
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: |