1. Get Started with Performance Tuning
  2. SQL Tuning
  3. Optimizing Data Access Paths
  4. Running SQL Access Advisor

Running SQL Access Advisor

This section describes how to run SQL Access Advisor to make recommendations for a SQL workload.

To run SQL Access Advisor:

  1. Select the initial options, as described in "Selecting the Initial Options".

  2. Select the workload source you want to use for the analysis, as described in "Selecting the Workload Source".

  3. Define the filters options, as described in "Applying Filter Options".

  4. Choose the types of recommendations, as described in "Specifying Recommendation Options".

  5. Schedule the SQL Access Advisor task, as described in "Specifying Task and Scheduling Options".