Display Execution Plan for a Query

When you use Microsoft SQL Server Management Studio to create a query to a SQL Server Compact 3.5 (SQL Server Compact 3.5) 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 SQL Server Management Studio.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 3.5.

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 Query

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)