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

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
SET STATISTICS XML OFF
GO

2. As it is explained that SET STATISTICS XML is an XML version of the actual

execution plan, it will execute the previous query and generate the actual execution
plan also. Have a look at the following screenshot: