In the Configuration 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 before and after the configuration parameters were changed.
Displays all the SQL statements and shows the SQL Classification (Simple, Complex, and Problematic) before and after the configuration parameters were changed.
The detailed information about the SQL statements used in the Analysis displays in the button pages. The buttons for displaying specific information are found at the top of this pane.
Displays general information about the SQL statement and the database settings at the time of the analysis.
Displays the SQL text in the top portion of the right pane and two SQL Information panes, one for the SQL information before the analysis and one for the SQL information with the parameter changes, in the bottom right pane.
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 a Configuration Analysis:
The New Analysis wizard has three pages for selecting the options for creating an analysis:
|Analyzer||New Analysis Wizard: Analyzer Page|
|Selected SQL||New Analysis Wizard: Select SQL page|
|Configuration||New Analysis Wizard: Configuration Page|
|Abstract Plan||New Analysis Wizard: Abstract Plan|
To abort the Configuration analysis
Select Analysis | Abort Analysis.