You can filter the Index Sets displayed on the Time tab and the Statistics tab of the Index Advisor window by any of the run time statistics after you have executed the SQL statement with the Index Sets.
The current filter displays in the bottom left corner of the Time or Statistics pane.
To filter the Index Sets
Click the downward pointing arrow to the right of a column heading.
Select one of the following:
Item | Description |
All |
Displays all the SQL statements. |
Custom… |
Opens the Custom AutoFilter window where you can select the options for filtering the SQL statements based on specific values for the selected column. |
Blanks |
Select all the SQL statements which do not have a value in the selected column. |
NonBlanks |
Select all the SQL statements which do have a value in the selected column. |
Specific Value |
Select all SQL statements that have one specific value. |
You can repeat steps 1 and 2 to add as many filters as you would like.
To clear the filter
Click at the bottom left corner of the Time or Statistics pane.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center