Listing 2: Examining XML Plans for a Query

SET SHOWPLAN_XML ON
GO
SELECT C.CustomerID,
PurchaseOrderNumber, count(*)
FROM OrderHeader H JOIN Customer C
   ON H.CustomerID = C.CustomerID
GROUP BY C.CustomerID,
   PurchaseOrderNumber
GO
SET SHOWPLAN_XML OFF
GO
SET STATISTICS XML ON
GO
SELECT C.CustomerID,
   PurchaseOrderNumber, count(*)
FROM OrderHeader H JOIN Customer C
   ON H.CustomerID = C.CustomerID
GROUP BY C.CustomerID,
   PurchaseOrderNumber
GO
SET SHOWPLAN_XML OFF
GO