Running SQL Access Advisor: Filter Options

After the workload source is selected, you can optionally apply filters to reduce the scope of the SQL statements found in the workload. Filters are beneficial for the following reasons:

• Using filters directs SQL Access Advisor to make recommendations based on a specific subset of SQL statements from the workload, which may lead to better recommendations.

• Using filters removes extraneous SQL statements from the workload, which may greatly reduce processing time.

To apply filters to the workload source: 

1. On the SQL Access Advisor: Workload Source page, click Filter Options.

   The Filter Options section expands.

2. Select Filter Workload Based on these Options.

   The Filter Options section is enabled.

3. Define the filters you want to apply, as described in the following sections:

   • Defining Filters for Resource Consumption

   • Defining Filters for Users

   • Defining Filters for Tables

   • Defining Filters for SQL Text

   • Defining Filters for Modules

   • Defining Filters for Actions

4. Click Next.

   The Recommendation Options page appears.

5. Proceed to the next step, as described in "Running SQL Access Advisor: Recommendation Options".