@@SHOWPLAN (SQL Server Compact)

Retrieves cached Showplan information.

Syntax

SELECT @@SHOWPLAN

Return Value

XML document that contains Showplan information.

Remarks

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

See Also

Reference

SET SHOWPLAN_XML (SQL Server Compact)
SET STATISTICS XML (SQL Server Compact)

Other Resources

Display Execution Plan for a Query
How to: View the Execution Plan for a SQL Server Compact Query

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)