From the course: SQL Server 2012: Designing Database Solutions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Working with query plans

Working with query plans - SQL Server Tutorial

From the course: SQL Server 2012: Designing Database Solutions

Start my 1-month free trial

Working with query plans

- In this section, I'd like to talk about one of the tools available to us to help us plan what indexes we're going to create and that is the query execution plan. On the standard tool bar, just to the right of the debug, there is an option for display estimated execution plan. I'll go ahead and click on that and we'll see that it pulls up underneath my query, some graphical elements. I'll re-size some windows so we can see that a little better. The top part Query 1 is just the drop clean buffers. That's not what we're interested in. We're much more interested in the bottom part of this which is the execution plan for the select top 200 carrier tracker numbers. Execution plans are read from right to left instead of like most things in the English language, we read from left to right, but query execution plans go the opposite way. They go from right to left. So we'll see the first step is this one all the way on the right, the index seek and if we hover our mouse over that, we can see…

Contents