General steps for tuning query workloads

In most cases, to tune a query workload, you can follow these steps.

Before you begin

About this task

To learn about the types of recommendations that are available, see Advisors for tuning query workloads.

Procedure

  1. Create the query workload, if it does not already exist.
  2. Schedule the collection of EXPLAIN information for the SQL statements that are in the workload.
  3. Get recommendations from the workload advisors.
  4. Review the recommendations that the advisors generated and tune the SQL statements in the workload according to those recommendations.

Feedback