Export (0) Print
Expand All
Expand Minimize

Retrieves cached Showplan information.



SELECT @@SHOWPLAN


XML document that contains Showplan information.


SQL Server Compact 3.5 can cache the query execution plan information as a Showplan XML document. To enable caching for estimated and actual execution plans, the Transact-SQL statements SET SHOWPLAN_XML and SET STATISTICS XML can be used.

Query plan information can also be viewed graphically through SQL Server Management Studio.

The document that contains the XML schema for the XML Showplan is copied during setup to a local directory on the computer on which SQL Server is installed. It can be found on the drive that contains the SQL Server installation files:

\Microsoft SQL Server\<SQL Server Version>\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml.xsd

The Showplan Schema can also be found at this Web site.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft