SQL Optimizer for DB2 LUW 4.4.1 - Installation Guide

Add Scenario

After creating an Index Impact Analysis, you can add more Scenarios to it. A Scenario can be added in two ways:

To add a Scenario to an Analyzer

Method One

1. In the left pane, right-click the Analyzer and select Add Scenario.

2. Click the Index page and specify the information for the proposed new indexes.  

Method Two

1. In the left pane, right-click an Analyzer and select New Analysis.

2. Select the Continuing an existing Analyzer using the Analyzer’s selected SQL option.

3. From the Select Analyzer box, click the Analyzer name.

4. Click the Index page and specify the information for the proposed new indexes.