View Index Impact Analysis Details
The Index Impact Analysis Details window displays information about the creation of the indexes and the retrieval of the access plans. The Index Impact Analysis Details window appears after the Index Impact Analysis process is completed unless the Show details on next generation checkbox in the Index Impact Analysis Details window is unchecked.
To view the Index Impact Analysis Details window
After an Index Impact Analysis is complete, select View | Last Index Impact Analysis Details when the Index Impact Analyzer window is active.
Review this information to see if an error occurred during the retrieval of the access plan. Errors may occur if the selected SQL statements are from one schema and you have set another schema in the Schema list at the bottom left of the main window.
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
-
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.
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
-
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.
Method Two
-
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.
Modify Index Impact Analyzer
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.