If a SQL statement has regressed, you can create a plan
hint for it. With a plan hint, you can set certain criteria to assist
the cost-based optimizer in selecting the optimal execution plan.
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.
- Click the View Comparison Result icon
and drill down to review the SQL Statements section.
- Select the SQL statement that regressed and click the Create
Plan Hint icon.