SQL Server Showplan Operator – Part 2

Home/Administration, SQL Server/SQL Server Showplan Operator – Part 2

SQL Server Showplan Operator – Part 2

$15.00 $4.00

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 sort and spool ShowPlan operator. In the second exercise we will look into parallel execution plan and in the third and final exercise we will look into sequence project, concatenation, constant scan, assert show plan operators.

Exercise 1: SORT and SPOOL Show Plan Operators
Exercise 2: Parallel Execution Plan
Exercise 3: SEQUENCE PROJECT, CONCATENATION, CONSTANT SCAN and ASSERT Show Plan Operators

Categories: ,

Description

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 sort and spool ShowPlan operator. In the second exercise we will look into parallel execution plan and in the third and final exercise we will look into sequence project, concatenation, constant scan, assert show plan operators.

Exercise 1: SORT and SPOOL Show Plan Operators
Exercise 2: Parallel Execution Plan
Exercise 3: SEQUENCE PROJECT, CONCATENATION, CONSTANT SCAN and ASSERT Show Plan Operators

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.