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

Reading query plans

To better understand what the query processor is doing, we need a way to look at query plans. SQL Server has several different ways of displaying a query plan; these techniques are collectively referred to as “the showplan options.”

SQL Server supports three showplan options: graphical, text, and XML. Each showplan option outputs the same query plan. The difference between these options is how the information is formatted, the level of detail included, how to read it, and how to use it.

Graphical plans

The graphical showplan option uses visually appealing icons that correspond to the iterators in the query plan. The tree structure of the query plan is clear. Arrows represent the data flow between the iterators. ToolTips provide ...

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