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

Access plans will be grouped under a Scenario

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

Item

Description

Name

Enter a name for the Scenario.

Description

Enter a description.

Add Index

Click image\B_AddIndex.gif.

Item

Description

Index Name

Enter a name for the index.

Schema

Select a name for the index.

Table

Select a table for the index.

Table columns

Double-click one or more columns.

Index type: Unique, Clustered, Allow Reverse Scans

Select the type of index.

 

Remove Index

Click image\B_RemoveIndex.gif.

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