Our Artificial Intelligence engine will analyze your execution plan and determine how to change it so SQL Server executes the operations more efficiently.
We've improved the execution plan visualization so it's easier to understand and faster to locate the operations that are slowing down the execution of your SQL.
We'll analyze your SQL and then automatically rewrite it until we find the variation that creates the most improvement in the execution time of the SQL.
We highlight changes in the SQL statement so you can compare the original statement with the optimized version before applying any changes.
Once you've optimized your SQL we show you the original plan and the optimized plan so you can compare them and see what's changed.
So you can see exactly why the optimized SQL statement is executing faster than the original we provide detailed statistics to give you the full picture.
Basic is perfect for analyzing your execution plans and providing advice and scripts to make the plans more efficient.