Tuning a query workload from the access plan comparison

If any SQL statements regressed, you can create a query workload to tune the statements.

Before you begin

Compare access plans for SQL statements from packages or compare access plans of different EXPLAIN snapshots of a workload.

Procedure

  1. In the Manage and Tune page of the workflow assistant, select a workload that contains the access plan comparison results.
  2. To review the previous comparison sessions for the workload, click the View Comparison Result icon.
  3. In the Comparison History page, select a comparison session from the table and click the Generate New Query Workload for Tuning icon. You can apply a filter to select a subset of the SQL statements from the comparison source or target access plan for tuning

What to do next

You can invoke advisors to get tuning recommendations for the query workload.

Feedback