You can filter the SQL statements displayed on the Time tab and the Statistics tab of the SQL Optimizer window by any of the run time statistics after you have executed the SQL statements so that the run time statistics are displayed on the Time tab and the Statistics tab.
The current filter displays in the bottom left corner of the Time or Statistics pane.
To filter the SQL statements
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 
