New Analysis Wizard: Index Page
View 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.
Name
Enter a name for the Scenario.
Description
Enter a description.
Enter and select indexes to be analyzed
Use Add Index to add the indexes for this Scenario.
Segment
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 Index
To remove an index
Select the index and click Remove Index 
After you have created the first Scenario, you can add more Scenarios.