Hands-On-Lab: SQL Server Showplan Operators – Part 1

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Showplan Operators – Part 1.

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, we will look into a nested loop, merge and hash join operators and in the fourth and final exercise we will look into the stream and hash aggregate operators.

Exercise 1: Different Ways to View Query Execution Plan
Exercise 2: SEEK, SCAN and LOOKUP Show Plan Operators
Exercise 3: NESTED LOOP, MERGE and HASH JOIN Show Plan Operators
Exercise 4: STREAM and HASH Aggregate Show Plan Operators

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.