Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Installation Guide

New Analysis Wizard: Index Page

In the New Analysis wizard, the Index page is used to specific the index(es) that are used for this analysis.

Query plans will be grouped under a Scenario

An individual Index Impact Analyzer consists of a group of stored SQL statements with the query plans called the "Baseline Plan." The actual Impact Analysis displays in a "Scenario." A Scenario shows the comparison information for the stored SQL statements identifying the impact on the query plan that the creation of new index will have.


Enter a name for the Scenario.


Enter a description.

Enter and select indexes to be analyzed

Use Add Index to add the indexes for this Scenario.


Select the segment where you would like the index created from the drop-down list.

Consumer (Default 1 Range 1-20)

Specify the number of consumer processes that should perform the sort operation for creating the index. The actual number of consumer processes used to sort the index may be smaller than the specified number, if fewer worker processes are available when Adaptive Server executes the sort.

To add an index

Click Add Indeximage\B_AddIndex.gif to bring up the Add Index wizard.

To remove an index

Select the index and click Remove Index image\B_RemoveIndex.gif.

After you have created the first Scenario, you can add more Scenarios.


Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating