@@SHOWPLAN (SQL Server Compact)
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
SET SHOWPLAN_XML (SQL Server Compact)
SET STATISTICS XML (SQL Server Compact)
Display Execution Plan for a Query
How to: View the Execution Plan for a SQL Server Compact Query