Creating a SQL Tuning Set: Filter Options

After the load method is selected, you can apply filters to reduce the scope of the SQL statements found in the SQL Tuning Set. While using filters is optional, it can be very beneficial due to the following:

• Using filters directs the various advisors that use the SQL Tuning Set as a workload source, such as SQL Tuning Advisor, SQL Access Advisor, and SQL Performance Analyzer, to make recommendations based on a specific subset of SQL statements, which may lead to better recommendations.

• Using filters removes extraneous SQL statements from the SQL Tuning Set, which may greatly reduce processing time when it is used as a workload source for the various advisors.

To specify filter options for a SQL Tuning Set: 

1. On the Create SQL Tuning Set: Filter Options page, specify the values of filter conditions that you want use in the search in the Value column, and an operator or a condition in the Operator column.

   Only the SQL statements that meet all of the specified filter conditions will be added to the SQL Tuning Set. Unspecified filter values will not be included as filter conditions in the search.

   By default, the following filter conditions are displayed:

   • Parsing Schema Name

   • SQL Text

   • SQL ID

   • Elapsed Time (sec)

2. To add filter conditions, under Filter Conditions, select the filter condition you want to add and click Add a Filter or Column.

   After the desired filter conditions have been added, specify their values in the Value column, and an operator or a condition in the Operator column.

3. To remove any unused filter conditions, click the icon in the Remove column for the corresponding filter condition you want to remove.

4. Click Next.

   The Create SQL Tuning Set: Schedule page appears.

5. Proceed to the next step, as described in "Creating a SQL Tuning Set: Schedule".