SQL Server - Compare Execution Plan

In SQL Server 2016, one of the SSMS enhancement is option to compare query execution plan.

This is how we can compare execution plan in SQL Server Management Studio 2016:

For Example:

I have create a table and inserted some records into it and then selected that table with execution plan and then saved that execution plan (*.Sqlplan) - > by right clicking on execution plan

Then created Index on the above created table, selected that table again with execution  plan.

Now to compare execution plan of SELECT query with and without index:

On the Result window -> Execution Plan -> right-click -> Compare ShowPlan

Tested in Microsoft Azure VM - SQL Server 2016 CTP 3.2

See Also: 

No comments: