The analysis will indicate whether the Query Plan can be tuned to improve performance, or whether the SQL Statement can be rewritten to optimize its efficiency.
If the SQL is a candidate for optimization you simply click the "Optimize" button and our rewrite engine creates a number of variations of the SQL. From these variations we then select the SQL that improves execution time the most and display the results for you to review.
This video shows you how easy it is to optimize your SQL within SQL Server Management Studio using Spotlight Tuning Pack Professional.
We demonstrate how the tool analyzes your SQL statements, and then automatically rewrites them over and over again until it finds a variation that creates the most improvement in the execution time of the SQL.
When viewing a SQL statement that has been optimized, with a single click on the plan tab you can compare the original execution plan with the optimized one. This enables you to see the changes that the rewrite has introduced to the plan.