Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

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.


Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating