Learn T-SQL Querying

Operator-level properties

Analyzing the plan-level properties provides context for the overall plan and the system in which the query plan executed. After that step, it's very important to keep in mind some of the key properties that can be found in the query plan operators of interest that we discussed earlier in the Query plan properties of interest section in this chapter.

The following example shows a query executed in the AdventureWorks sample database that allows us to examine most of these properties:

SELECT *FROM Sales.SalesOrderDetail AS sodINNER JOIN Production.Product AS p ON sod.ProductID = p.ProductIDWHERE p.ProductID BETWEEN 850 AND 860ORDER BY Style DESCOPTION (USE HINT('ENABLE_PARALLEL_PLAN_PREFERENCE'));

The query generates ...