Operators describe how SQL Server executes a query or a Data Manipulation Language (DML) statement. The query optimizer uses operators to build a query plan to create the result specified in the query, or to perform the operation specified in the DML statement. The query plan is a tree consisting of physical operators. We can view the query plan by using the SET SHOWPLAN statements, the graphical execution plan options in SQL Server Management Studio, or the SQL Server Profiler ShowPlan event classes. Operators are classified as logical and physical operators. In the first exercise of this lab, we will explore different ways to view query execution plan. In the second exercise, we will look into different seek, scan and lookup operators. In the third exercise

Subscribe to Download


Version1.0
Download13
File Size895.73 KB
Create DateSeptember 7, 2016
Last UpdatedOctober 11, 2016
SQL Server Storage Internals Part 2
SQL Server Resource Governor