In the Index Usage Analyzer window, when the SQL Analyzed folder is selected in the left pane, the following information displays in the right pane.
Displays all the SQL statements and shows the tables and indexes used.
When a SQL statement is selected in the left pane, the following information displays in the right pane.
Displays general information about the analysis, information on the connection used to retrieve the query plans and the database settings at the time of the analysis.
Displays the query plan and the SQL Information pane.
Displays the table name, the index name, and the index key for the indexes used by the SQL statement. Use the Right-click menu to Save the list of indexes.
To create an Index Usage Analysis
The New Analysis wizard has two pages to select the options for creating an analysis.
Make the selections from these two tab page. Click OK.
When the analysis is finished, the Index Usage Analysis Details window displays with information about the retrieval of the query plan for each SQL statement.