Wednesday, December 24, 2014

SQL Server query execution plans – Viewing the plans





Source:SQL Server query execution plans – Viewing theplans

 ..

If you look at the Query item in the SQL Server Management Studio menu, you’ll see two options related to query plans – Display Estimated Execution plan and Include Actual Execution plan
An estimated execution plan is a SQL Server query plan that is generated without actually running the query (or stored procedure) the plan is created for.
...

 

 

No comments:

Post a Comment