Databases Reference
In-Depth Information
3.
Since this is not like an estimated execution plan,
SET
STATISTICS
XML
will execute
the query and will generate the actual execution plan in XML format, so you will find
two result sets in the Results tab. The first result set shows the result of the query
and the second result set shows link to open the plan. Click on the link and you will
be forwarded to the graphical actual execution plan window:
4.
Right-click on the graphical plan and select the Show Execution Plan XML… option
and you will be forwarded to the XML plan:
Search WWH ::
Custom Search