Execution Plan How-to Topics
This section explains how to display execution plans and how to save execution plans to a file in XML format by using Microsoft SQL Server Management Studio.
Execution plans graphically display the data retrieval methods chosen by the SQL Server query optimizer. Execution plans represent the execution cost of specific statements and queries in SQL Server using icons rather than the tabular representation produced by the SET SHOWPLAN_ALL or SET SHOWPLAN_TEXT statements. This graphical approach is very useful for understanding the performance characteristics of a query. For more information, see Displaying Graphical Execution Plans (SQL Server Management Studio).
In This Section
- How to: Display the Estimated Execution Plan
- How to: Display an Actual Execution Plan
- How to: Save an Execution Plan in XML Format
See Also
Concepts
Graphical Execution Plan Icons (SQL Server Management Studio)