Right Pane for SQL Statements
In the Index Impact Analyzer window, when a SQL statement is selected in the left pane, the following information displays in the right pane.
Properties button
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.
SQL Information button
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.
Saving the Abstract Plan
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.
-
Click Save.
.