To create an Index Usage Analysis
If no analysis exists in the Index Usage Analyzer then the New Analysis wizard displays automatically. Otherwise, click .
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.
The Analyzer page is used to name the analysis and to select the folder where the Analyzer information will be stored.
Item | Description |
Name |
Enter the name for the analysis. |
Description |
Enter the description for the analysis. |
Last modified |
Displays the last modified date and time. |
Save location |
Displays the folder in the tree where the analysis is saved. In the bottom pane, select the folder where you want to save the analysis. To create a new folder
|
The Select SQL page is used to select the SQL statements whose query plans you want to analyze to see which Indexes are used and which are not used by these SQL statements.
Select SQL from
The SQL statements used in an analysis can be taken from the SQL Repository or the SQL Scanner. If you select SQL statements from the SQL Scanner, these statements are added to the SQL Repository.
Select the SQL statements for the analysis.
You can update an analysis for unused indexes by rerunning the analysis with the same SQL statements from the original analysis or you can add or delete SQL statements from the analysis.
To update an analysis
Right-click the analysis name in the left pane of the Index Usage Analysis window and select Update Analysis. The Update Analysis window has two tabs to select the options for changing an analysis before it is updated. It is not necessary to make any changes on these tabs before rerunning the analysis.
On the Analyzer tab, you can change the name and description of the analysis.
On the Selected SQL tab, you can add or delete SQL statements to the analysis.
After making the selections from the two tabs, click OK.
When the analysis is finished, the Index Usage Analysis Details window displays with information the retrieve of the query plan for each SQL statement.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center