The Index Impact Analyzer window displays the information about the SQL statements that are saved in the Index Impact Analyzer. The display in the right section of the window depends on what is selected in the left pane.
Always displays a tree diagram of the Analyzers and the folders they are stored in.
The right pane displays a variety of different information depending upon what is selected from the tree diagram in the left pane.
You can display information for the following:
In the Index Impact Analyzer window, when an Analyzer is selected in the left pane.
The Properties displays the following information:
General information about the analysis
Connection information used to retrieve the access plans and the SQL statements used in the analysis
Connection information used to retrieve the Baseline access plans
Indexes used for each Scenario
SQL Information for each SQL statement used in the analysis
In the Index Impact Analyzer pane, the following information is displayed in the right pane.
Provides a summary of the DB2 LUW Cost and SQL classification for the SQL statements before and after the proposed indexes were created.
Displays a bar chart which compares the accumulative total of the DB2 LUW Cost for the Baseline to each of the Scenarios. The Baseline shows the accumulative total of the DB2 LUW Cost of the SQL statements without the proposed indexes. The other bars show the accumulative total of the DB2 LUW Cost with the each proposed index set.
In the Index Impact Analyzer window, when the Scenario folder is selected in the left pane, the following information is displayed in the right pane.
Displays general information about the analysis and the index name.
Displays 3 panes in the right section of the window.
The Chart tab displays charts of the comparison information for the access plans from before the analysis and during the analysis. These charts compare:
Total DB2 LUW cost for all SQL statements
Number of SQL statements with changes in the DB2 LUW cost
Number of SQL statements that use the indexes in the index set
Number of SQL statements whose access plan is different from the Baseline access plan
Number of SQL statements whose SQL classification changed
Number of SQL statements in each of the SQL classification categories
The Summary tab displays summarized statistics for the Scenario.
A grid displays the information about each access plan from before the analysis and during the analysis in a comparison format.
The SQL statement that is highlight in the middle right pane is the one that is displayed in this pane.
The SQL Text tab displays the text of the SQL statement.
The SQL Information tab displays two SQL Information panes, one for the SQL information without the index set and one for the SQL Information with the index set. The SQL Information panes contain buttons that show the access plans, DB2 LUW Optimized Text, SQL Classification, and any temporary tables used for the statement with and without the Index Set. As you review the access plans, the differences between the plan with and without the index set will be highlight in green to make it easier to find the differences.
Displays the script for creating the index or indexes.
To create the indexes
Review the index name and, if desired, modify it.
Click 
