Index Usage Analyzer Tutorial

Index Usage Analyzer Tutorial

The Index Usage Analyzer identifies the usage of the indexes in your database application by uncovering both the indexes that are being used and the indexes that are not being unused. It analyzes the access plans from SQL statements in the SQL statements that are save in the SQL Repository. 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.

1. Click .

2. Click . If this is your first time in the Index Usage Analyzer, the New Analysis window automatically opens.

Analyzer Tab

3. Give the analysis a name and description for easy reference.

4. If you would like to create a folder, click .

Select SQL Tab

5. Select the source of the SQL statements for Analysis: SQL Repository or SQL Scanner.

6. Select the SQL statements to add to the Analysis from your predefined SQL statements, or you may add a statement to this Analysis by clicking .

7. Click OK.

Reviewing Index Usage Analyzer Results

8. 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.

9. In the right pane, click the Index Summary button to see a list of indexes used and unused.

Related Topics

Index Usage Analyzer Overview

Index Usage Analyzer Window

Index Usage Analyzer Functions