After applying tuning recommendations, such as recommendations
from the Statistics Advisor or the Index Advisor, you can compare
access plans for a tuned workload. By using different EXPLAIN snapshots,
you can validate that the SQL statements in the tuned workload have
been optimized.
Tip: You should specify as the source an
EXPLAIN snapshot of a workload that was taken from before the tuning
recommendation was applied. You should specify as the target an
EXPLAIN snapshot of the same workload that was taken from after the
tuning recommendation was applied.