Create an Index Usage Analysis
To create an Index Usage Analysis
-
Click
.
-
If no analysis exists in the Index Usage Analyzer, then the New Analysis wizard appears automatically. Otherwise, you can open the New Analysis wizard in the following ways:
-
Click
.
-
Use the following pages in the New Analysis wizard to select the options for creating an analysis.
When the analysis is finished, the Index Usage Analysis Details window appears with information about the retrieval of the access plan for each SQL statement.