screen-tour-optimizer

Every recommendation is automatically benchmarked against the copy-of-production database. Qure Optimizer replays the trace activity (ie, workload), applies the recommendations, and then re-runs the workload to measure actual performance improvement.

Recommendations for SQL rewrites include a side-by-side comparison of the original SQL and the alternative syntax, as well as a detailed explanation.