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
- In the Manage and Tune page of the workflow assistant,
select a workload that contains the access plan comparison results.
- To review the previous comparison sessions for the workload,
click the View Comparison Result icon.
- 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.