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

  • Article

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

  1. Open SQL Server Management Studio.

  2. If there is no query in the query pane, open a saved query or create a new query.

  3. 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.

  4. On the Query menu, click Query Execute.

See Also

Other Resources

Querying Databases (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance