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

How to: View the Execution Plan for...

Collapse All

Other versions are also available for the following:

SQL Server Compact 3.5 Service Pack 1 Books Online

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

To view the execution plan for a 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.