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
From the left pane, select the Analyzer in which you want to add the SQL.
Right-click and select Add SQL.
In the Add SQL window under the Select SQL to be added pane, check the SQL statements you want added.
Under the Select Scenario to include SQL pane, check the Scenarios you want the SQL added to.
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
In the left pane, right-click the Analyzer and select Add Scenario.
Click the Index page and specify the information for the proposed new indexes.
In the left pane, right-click an Analyzer and select New Analysis.
Select the Continuing an existing Analyzer using the Analyzer’s selected SQL option.
From the Select Analyzer box, click the Analyzer name.
Click the Index page and specify the information for the proposed new indexes.
To modify the analysis name or description
From the Index Impact Analyzer window, select the Analyzer you want to modify from the left pane.
Right-click and select Modify to open the Modify Analyzer window.
Modify the name or description.
The Scenario can be re-executed using the same indexes. You can choose to retrieve the access plans for all SQL statements in the Scenario or select specific SQL to retrieve the access plan again using the same indexes.
The function is useful if changes have occurred in the database environment, such as data volume changes, that may affect access plans.
To regenerate the access plan
Select the Scenario from the left pane.
Right-click and select Regenerate.
Check the SQL statements whose current access plans you would like retrieved again.
