Viewing the execution plan for a specific Sproc

Views – 697

Execution Plan Notes

Clustered Index Seek: performed where there is a WHERE clause and the search parameter is included in the clustered index. Clustered Index Scan:…

SQL Server 2012 Internals

Life Cycle of a Query The command parser evaluates the query and generates a hash to see if the buffer pool has an…