Index Usage Analyzer Tutorial
The Index Usage Analyzer identifies unused indexes by analyzing query plans from SQL statements in your database applications. It examines their query plans and reports any indexes in the database that are not used. You can use this module to quickly identify the indexes in databases that are not contributing to the performance of the database applications These unused indexes can then be deleted to free up space and improve the speed of the database applications and maintenance.
-
Click
.
-
Click
. If this is your first time in the Index Usage Analyzer, the New Analysis wizard automatically opens.
Analyzer Page
-
Give the analysis a name and description for easy reference.
-
For better organization, create a folder for the analysis you are creating by clicking
.
Select SQL Page
-
Select the source of the SQL statements for Analysis: SQL Repository or SQL Scanner.
-
Select the SQL statement(s) to add to the Analysis from your predefined SQL statements or you may add a statement to this Analysis by selecting
.
-
Click OK.
Review Unused Index Analyzer Results
-
After the analysis, you can see the overall results by clicking the Analyzer, and its related information, in the tree structure in the left pane and viewing the corresponding information in the panes to the right.
-
In the right pane, click Index Summary to see a list of indexes used and unused.