You can find out whether the access plans for a query workload
would be improved by recommendations from the Workload Index Advisor.
About this task
In this procedure, you generate an EXPLAIN snapshot just
before running the Workload Index Advisor. You also generate a virtual
EXPLAIN snapshot that makes use of the recommendations that the Workload
Index Advisor generates. You then run a comparison of these two EXPLAIN
snapshots.
To compare access plans by using snapshots of EXPLAIN
information after generating index recommendations:
What to do next
On the
Comparison History page,
double-click the entry for the comparison. On the
View Comparison
Results by Workload EXPLAIN Snapshots and SQL Statements page,
review the
Statements table to look for statements
with differences in the two EXPLAIN snapshots. If you need to share
the results with other people, select
Generate Comparison
HTML Report in the
More actions field
above the table.