SQL Server with Mr. Denny

Oct 29 2007   8:00AM GMT

Easy way to read XML execution plans.



Posted by: mrdenny
SQL, Execution Plan

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it.  It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.

Comment on this Post


You must be logged-in to post a comment. Log-in/Register

Checking the cached execution plans - SQL Server with Mr. Denny  |   May 1 2008   9:03AM GMT

[…] Don’t forget how to view the XML execution plan in the UI. […]