In the Index Impact Analyzer window, when a SQL statement is selected in the left pane, the following information is displayed in the right pane.
Displays general information about the analysis, information on the connection used to retrieve the access plans at the time of the analysis.
Displays the SQL statement selected as well as two SQL Information panes 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.
