You can compare the differences in the access plans that
are produced by two separate virtual tests of candidate indexes.
About this task
In this procedure, you run a virtual test of a set of indexes,
which are called candidate indexes because they are candidates for
being created, altered, or dropped. When you run the test, a virtual
EXPLAIN snapshot is generated. This virtual snapshot makes use of
the results of the test. You then run a second virtual test and generate
a second virtual EXPLAIN snapshot. Finally, you compare both virtual
EXPLAIN snapshots.
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.