Using an Existing SQL Tuning Set

You can use an existing SQL Tuning Set as the workload source. This option is useful because SQL Tuning Sets can be used repeatedly as the workload source for SQL Access Advisor and SQL Tuning Advisor.

To use a SQL Tuning Set as the workload source: 

1. On the SQL Access Advisor: Workload Source page, select Use an existing SQL Tuning Set.

2. Click the SQL Tuning Set search icon to use an existing SQL Tuning Set.

   The Search and Select: SQL Tuning Set dialog box appears.

3. In the Schema field, enter the name of the schema containing the SQL Tuning Set you want to use and then click Go.

   A list of SQL Tuning Sets contained in the selected schema appears.

4. Select the SQL Tuning Set to be used for the workload source and click Select.

   The Search and Select: SQL Tuning Set dialog box closes and the selected SQL Tuning Set now appears in the SQL Tuning Set field.

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