O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Analyzing plans

To really understand query plans and really be able to spot, fix, or work around problems with query plans requires a solid understanding of the query operators that make up these plans. Overall, too many operators are available to discuss them in one chapter. Moreover, you can combine these operators into query plans in innumerable ways. Thus, this section focuses on understanding the most common query operators—the most basic building blocks of query execution—and give some insight into when and how SQL Server uses them to construct a variety of interesting query plans. Specifically, this section looks at scans and seeks, joins, aggregations, unions, a selection of subquery plans, and parallelism. After you understand how these ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required