Display Execution Plan for a Query
When you use Microsoft to create a query to a SQL Server 2005 Compact Edition (SQL Server Compact Edition) database, you can see a graphical representation of the execution plan with the Display Estimated Execution Plan command. You can access this command from the Query menu in Microsoft .This graphical image lets you examine the details of the plan, at the time of compile or at run time, and to compare queries.
During query execution, statistics about the query are captured, organized into XML data, and stored in a system table on the database. The Display Execution Plan command retrieves the XML data from the system table and renders a diagram based on the XML information. You can also access the graphical execution plan directly with SQL Server Compact Edition.
Note
The Display execution plan is valid only for Data Manipulation Language (DML) statements. The execution plan is not displayed for Data Definition Language (DDL) statements.
See Also
Tasks
How to: View the Execution Plan for a SQL Server Compact Edition Query