Monitoring with Execution Plans - Microsoft SQL Server 2012 Performance Tuning - page 95

[Purchasing].[PurchaseOrderDetail] AS POD
ON
POH.PurchaseOrderID = POD.PurchaseOrderID
JOIN
[HumanResources].[Employee] AS EMP
ON
POH.EmployeeID=EMP.BusinessEntityID
JOIN
[Purchasing].[Vendor] AS V
ON
POH.VendorID=V.BusinessEntityID
GROUP BY
POH.PurchaseOrderID
,POH.OrderDate
,EMP.LoginID
,V.Name
GO

2. Go to the Query menu and click on Include Actual Execution Plan or press Ctrl+M

which will display the estimated execution plan.

3. Now, execute the query, you will get the output of the query in the Result tab and

the graphical actual execution plan in Execution Plan tab. Have a look at the
following screenshot:

The same execution plan as shown in the previous screenshot is presented in text format as
follows with the help of SHOWPLAN_TEXT :

|--Stream Aggregate(GROUP BY:([POH].[PurchaseOrderID], [EMP].
[LoginID], [V].[Name]) DEFINE:([Expr1010]=Count(*), [Expr1008]=SUM([
AdventureWorks2012].[Purchasing].[PurchaseOrderDetail].[OrderQty] as
[POD].[OrderQty]), [Expr1009]=SUM([Expr1011]), [POH].[Or
|--Sort(ORDER BY:([POH].[PurchaseOrderID] ASC, [EMP].[LoginID]
ASC, [V].[Name] ASC))