How To: View the Execution Plan for a SQL Server Compact Query
In this topic, you will learn how to view the execution plan for a Microsoft SQL Server Compact 4.0 query.
To view the execution plan for a query
Open Visual Studio 2010 SP1.
On the Data menu, select the Transact-SQL editor and connect. For more information on how to connect to Transact-SQL editor, see How To: Use Transact SQL (T-SQL) Editor for Queries.
If there is no query in the query pane, open a saved query or create a new query.
Right-click the editor, and then click Display Estimated 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 Transact-SQL Editor toolbar, click Execute SQL.