The Select SQL tab is used to select the SQL statements whose access plans you want to analyze to see which Indexes are used and which are not used by these SQL statements.
The SQL statements used in an analysis can be taken from the SQL Repository or the SQL Scanner.
Select the SQL statements for the analysis.
View the Index Usage Analysis Details Window
The Index Usage Analysis Details window displays information about the retrieve of the access plan for each SQL statement.
The Index Usage Analysis Details window appears after the batch run process is completed unless the Show details on next batch run checkbox in the Index Usage Analysis Details window is unchecked.
To view the Index Usage Analysis Details window
After an Index Usage Analysis is complete, select View | Last Index Usage Analysis Details when the Index User Analyzer window is active.
Review this information to see if an error occurred during the retrieval of the access plan. Errors may occur if the selected SQL statements are from one schema and you have set another schema in the Schema list at the bottom left of the main window.
To modify the analysis name or description
From the Index Usage Analyzer window, select the Analyzer you want to modify from the left pane.
Right-click and select Modify to open the Modify Analyzer window.
Modify the name or description.
You can rename an analysis in the Index Usage Analyzer window in two ways.
To rename an Analyzer
Select the Analysis you want to modify from the left pane.
Right-click and select Rename. Change the name and press Enter.
or
Right-click and select Modify and change the name.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center