In the New Analysis wizard, the Index page is used to specific the index(es) that are used for this analysis.
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.
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.
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 bring up the Add Index wizard.
To remove an index
Select the index and click Remove Index .
After you have created the first Scenario, you can add more Scenarios.