SQL Server 2008 R2

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

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.