The Workload Access Path Advisor examines the access plans
that are chosen by the optimizer and identifies certain common access
path issues.
Procedure
- In the Manage section, open
the Manage and Tune Workloads page.
- Select the query workload and click the Invoke
Advisors and Tools icon, which is on the left end of the
toolbar above the list of query workloads. The Run Workload
Advisors page of the Invoke section
opens.
- If you are running the Workload Query Advisor after running
the RUNSTATS commands that the Workload Statistics Advisor recommended
and the DDL statements that the Workload Index Advisor recommended,
ensure that the Re-explain the query workload check box
is selected. Now that the statistics for the SQL statement
are accurate and index recommendations are in place, the workflow
assistant must update the EXPLAIN information for statement.
- Click the Select What
to Run button.
- In the Select Activities window, select
the Access paths check box and click OK. After the Workload Access Path Advisor runs, the Review
Advisor Recommendations page of the Review section
opens. The Summary section shows whether there
are any recommendations for query revisions.
- In the Review Workload Advisor Recommendations page,
click the Access paths tab if there are new
recommendations.
- Specify the statements that you want to see the recommendations
for and click the Show Statements icon.
- In the Workload Access Path Advisor Details section,
select one of the statements and click the Show Query Details icon.
- Follow the recommendations that appear for the selected
SQL statement.
- Follow steps 8 through 10 until all of the recommendations
are implemented.