New Analysis Wizard: Index Page
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
| ||||||||||||
|
Remove Index |
Click |
.
.After you have created the first Scenario, you can add more Scenarios.