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
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
No comments:
Post a Comment