Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.