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 and 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 Migration Analyzer, the query plans for the selected SQL statements current database are compared to the query plans in the database for the migration. 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 database logon that is assumed to be the source Adaptive Server instance you are migrating from. This current query plan is compared to the query plan that is retrieved from the destination Adaptive Server instance for the migration.