Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

@@SHOWPLAN (SQL Server Compact)

Retrieves cached Showplan information.


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

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