Execution Plan is like a blueprint. SQL Server uses it to execute a DML query. As a DBA, understanding execution plans is like reading the X-ray of query performance. It exposes where SQL Server spent its time and resources, which indexes used or ignored, and area of performance bottlenecks.
In this article, you will go through how to analyze SQL Server execution plans, interpret key operators, and identify optimization opportunities.
[More]
In the previous article, you learnt about concepts of execution plan, operators, and their properties. In this article, you will learn about reading an execution plan.
[More]
When a query performs poorly and you fails to understand the reason behind it. You need to check the execution plan. However, reading an execution plan is like reading a new language. You need to understand the operators, their properties, data flows, meaning of icons, order of operators etc. In this article series, I am going to discuss this step by step.
[More]