SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Add SQL to an Index Impact Analysis

After creating an Index Impact Analysis, you can add more SQL statements from the SQL Repository to it. This process will re-execute the Scenario.

To add SQL statements

1. From the left pane, select the Analyzer in which you want to add the SQL.

2. Right-click and select Add SQL.

3. In the Add SQL window under the Select SQL to be added pane, check the SQL statements you want added.

4. Under the Select Scenario to include SQL pane, check the Scenarios you want the SQL added to.