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

In this topic, you will learn how to view the execution plan for a Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) query.

To view the execution plan for a SQL Server Compact Edition query

Open SQL Server Management Studio.
If there is no query in the query pane, open a saved query or create a new query.
On the Query menu, click Display Execution Plan.

A graphical representation of the execution plan is displayed. You can position the pointer over graphical elements to reveal additional execution plan information.
On the Query menu, click Query Execute.