Create an Index Impact Analyzer
To create an Index Impact Analyzer
-
Click
to open the Index Impact Analyzer window.
-
If no analysis exists in the Index Impact Analyzer then the New Analysis wizard displays automatically. Otherwise, click
to open the New Analysis wizard.
-
The New Analysis wizard the following pages to select the options for creating an analysis.
-
Name the Analyzer, select the SQL statements for analysis, and specify the DDL for the proposed indexes in the New Analysis window.
Note: The indexes are physically created and then dropped after the query plans are obtained. This may affect other SQL statements executing on the database during this period.