Creating a plan hint from an access plan comparison result

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

  1. In the Manage and Tune page of the workflow assistant, select a workload that contains the access plan comparison results.
  2. Click the View Comparison Result icon and drill down to review the SQL Statements section.
  3. Select the SQL statement that regressed and click the Create Plan Hint icon.

Feedback