| title | Compare and Analyze Execution Plans | Microsoft Docs | ||||||
|---|---|---|---|---|---|---|---|
| ms.custom | |||||||
| ms.date | 11/21/2018 | ||||||
| ms.prod | sql | ||||||
| ms.prod_service | database-engine, sql-database | ||||||
| ms.reviewer | |||||||
| ms.technology | performance | ||||||
| ms.topic | conceptual | ||||||
| helpviewer_keywords |
|
||||||
| ms.assetid | bcd6f094-c613-4835-ae19-4caaadb4bb17 | ||||||
| author | pmasl | ||||||
| ms.author | pelopes | ||||||
| manager | amitban |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This section explains how to compare and analyze execution plans by using Microsoft [!INCLUDEssManStudioFull]. This feature is available starting with [!INCLUDEssManStudioFull] v17.4.
Execution plans graphically display the data retrieval methods chosen by the [!INCLUDEssNoVersion] Query Optimizer. Execution plans represent the execution cost of specific statements and queries in [!INCLUDEssNoVersion] 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.
[!INCLUDEssManStudioFull] includes functionality that allows users compare two execution plans, for example between perceived good and bad plans for the same query, and perform root cause analysis. Also included is the functionality to perform single query plan analysis, allowing insights into scenarios that may be affecting the performance of a query through analysis of its execution plan.
For more information on query execution plans, see estimated execution plan, actual execution plan, and the Query Processing Architecture Guide.