Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

New Analysis Wizard: Analyzer Page

The Analyzer tab is used to name the analysis and to select the folder where the SQL statements that you want to analyze are stored.

Creating a new Analyzer and select SQL to be analyzed

Select this option to create a new analysis using a different set of SQL statements.

Continuing an existing Analyzer using the Analyzer's selected SQL

Select this option to use the same set of SQL statements that is stored in an existing Analyzer. This option adds another Scenario under an existing Analyzer and does not retrieve a new set of query plans for the SQL statements. It uses the query plans that were originally saved with the SQL statements.

Do not rollback changes to the ASE configuration parameters

Specific to leaves the database configuration changes that you select under the Configuration tab after the analysis is finished. Otherwise, these changes are rolled back at the end of the analysis processing. After the analysis is complete, the Apply/Undo Changes button displays at the top of the Migration Analyzer window which displays the Apply Changes and the Undo Changes panes. These panes contain the scripts to make changes to the Adaptive Server configuration parameters.

Item Description

Name

Enter the name for the analysis.

Description

Enter the description for the analysis.

Last modified

Displays the last modified date and time.

Save location

Displays the folder in the tree where the analysis is saved. In the bottom pane, select the folder where you want to save the analysis.

To create a new folder

Click Add Folder image\B_AddFolder.gif.

 

Related Topic

Related Documents