Learn SQL Server Execution Plans anywhere, anytime on your cell phone

Execution Plan Logo

SQL Server Execution Plan is SQL Server's roadmap to execute a query.

It reveals a lot of details about every single step SQL Server goes through.

Understanding Execution Plans helps figuring out query bottlenecks, query costs, query optimization, ...

Concepts invovled in Execution Plans are all interleaved together, which makes Execution Plans very difficult to learn. We have gathered all the requirements in one place, and untangled the difficulty. So, it's easy to learn.
You don't need to jump over multiple websites to understand what one single operator does.
Execution Plan Operator Execution Plan Operator Execution Plan Operator Execution Plan Operator Execution Plan Operator Execution Plan Operator Execution Plan Operator Execution Plan Operator

There are so many concepts you need to know in order to understand Execution Plans.
Buffer Pool, Physical Read, Logical Read, Page, Tipping Point, ....
We know all the concepts needed and have explained them all in a well sorted order to fully and easily understand Execution Plans.

What happens when a query is submitted?

What happens when a query is submitted?

SQL Server, most of the time, does not execute the exact query; It modifies the query internally to achieve results at a lower cost.

Tables are not read in the same order that are mentioned in the query; There are very weird reasons that SQL Server reads from tables in an absolutely different order than specified in the query.

Execution Plan reveals the ultimate modified version of query SQL Server executes.

How to read Execution Plans?

Reading Execution Plans is very tricky. It looks to be simple, however it's not.

You can get a whole idea by the icons in an Execution Plan, however, there are many important details that are hidden between the lines. You need to know the alphabets to be able to read, understand and analyze the Execution Plan.

In order to read Execution Plans, you need to know the related concepts and requirements that are not easily found in one place. We have created the one place for you to go and learn it all from A to Z.

How to read Execution Plans?

What does each operator mean in Execution Plans?

What does each operator mean in Execution Plans?

There are multiple algorithms to perform one single operation in SQL Server. Many ways to read from a table, or to perform an INNER JOIN, .....

Each of the algorithms has its own pros and cons; and SQL Server makes the good enough choice based on multiple criteria.

We help you understand the different algorithms, and the criteria by which SQL Server chooses one. And ultimately, you can make some changes to help SQL Server change the choice to an even better algorithm.

How does SQL Server look at queries?

The way SQL Server interprets queries is way different from human interpretation. From human perspectives, a table is just where data resides. However, from SQL Server's perspective, there are many other things associated with that table; Indexes, Statisics, fragmantation, ....

The different perspectives result in two absolutely different interpretations of a query. Understanding Execution Plans helps understand SQL Server's perspective and interpretation; and helps you tweak SQL Server to find a more efficient way of executing the query.

How does SQL Server look at queries?

Download SQL Server Execution Plans

SQL Server Execution Plans is a mobile app that gets you up to speed with the Execution Plans

This mobile app provides a fast and easy way of learning Execution Plans.
You will learn the Execution Plan alongside all the knowledge requirements in one single app.

Stop googling thousands of websites for one single concept, download the app now!

The app is currently offered on Android.