SET STATISTICS XML is an XML version of the actual execution plan. It provides all the information in XML format which we used to get in graphical format in the actual execution plan.
We are going to use the
SELECT query given in the previous recipe's How to do it... section by replacing
SET STATISTICS XML. The main intention to use the same query from the previous recipe Monitoring performance of query by SET SHOWPLAN_XML is to see the difference between two execution plan. Generally, if an index and statistics' histogram is updated, then the execution plan on sampling (estimated execution plan) and execution plan on real table (actual execution plan) remain ...