In the Index Impact Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information displays in the right pane.
Displays all the SQL statements and shows the Estimated I/O Cost with and without the proposed indexes.
Displays all the SQL statements and shows the SQL Classification (Simple, Complex, and Problematic) with and without the proposed indexes.
Displays general information about the analysis, information on the connection used to retrieve the query plans and the database settings at the time of the analysis.
Displays the SQL statement selected, as well as, two SQL Information panes that show the query plans for the statement before and after the index Scenario is in place. In the query plan, the operations that are different between the two plans are highlighted in green.
The abstract plan for a SQL statement can be saved from this pane. In order to save the abstract plan, it must be retrieved when the SQL was selected to be analyzed. This is done from the Abstract Plan page of the New Analysis wizard.
Select the SQL statement in the left pane.
Click SQL Information section of the right pane. This enables the Save Abstract Plan button.
In the Save to group field, select the abstract plan group.
To create an Index Impact Analyzer
Click to open the Index Impact Analyzer window.
The New Analysis wizard the following pages to select the options for creating an analysis.
Name the Analyzer, select the SQL statements for analysis, and specify the DDL for the proposed indexes in the New Analysis window.
Note: The indexes are physically created and then dropped after the query plans are obtained. This may affect other SQL statements executing on the database during this period.