Identify SQL performance changes due to applying tuning recommendations

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.

Feedback