New Analysis Wizard: Select SQL page
View New Analysis Wizard - Select SQL page
The Select SQL page is used to select the SQL statements whose query plans you want to analyze when various database parameters are changed.
Select SQL to check for performance changes:
Select SQL from
The SQL statements used in an analysis can be taken from the SQL Repository or the SQL Scanner. If you select SQL statements from the SQL Scanner, these statements are added to the SQL Repository.
SQL query plans will be analyzed:
In the Configuration Analyzer, the query plans for the selected SQL statements before the configuration change are compared to the query plans after the change. The following options allow you to determine the "before" query plans.
Using existing query plan saved with the SQL
This option uses the query plan that was saved with the SQL statement when it was saved in the SQL Repository or SQL Scanner.
Obtaining a new query plan under the current connection
This option retrieves the query plan with the current logon and the current database settings. This current query plan is compared to the query plan that is retrieved after the configuration changes are made.