Get Live Help
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:
To start a tuning session
Select one of the tabs shown as follows:
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.