Tuning an SQL statement listed in the Top SQL drilldown
You can tune SQL statements listed in the Top SQL drilldown if you have either of the following products licensed and installed on the same computer where your Spotlight on IBM® DB2® LUW client is installed:
- SQL Optimizer for DB2
To start a tuning session
- Open the Top SQL drilldown.
-
Select one of the tabs shown as follows:
- Select the Current SQL tab to tune currently executing statements.
- Select the Static SQL tab to tune static SQL statements.
- Select the Dynamic SQL tab to tune dynamic SQL statements.
-
From the list in the selected tab, click the row for the statement you want to tune. The detail pane for this statement appears in the lower half of the SQL tab
-
In the upper left of the detail pane, click the SQL Tuning icon
. SQL Optimizer for DB2 opens, showing the SQL statement in the product's main window.
- If you need instructions to proceed with the tuning session, click F1 for context-sensitive help.