31_mathQuiz

Reading Query Plans with the Showplan Options

This post is about the several ways of reading the query plan (called the showplan options). Now that we know what a query plan is, why it’s helpful and what it consists of (iterators), let’s find out how we can read the query plans in SQL Server. I believe most of you are familiar with Read More

31_mathQuiz

Properties of Iterators

In this post I will continue the discussion about iterators in the context of a query execution plan. This time, I will tell you about some of their most important properties and the things to take into consideration when investigating the performance of an execution plan.

31_mathQuiz

Query Execution Engine Introduction

This is the first post from my complex tutorial project called “Understanding Query Execution Plans”. This is an introductory post, in which I will  guide you through the concepts you need to know before starting to analyze the plans.