O'Reilly logo

SQL Server Execution Plans, 2nd Edition by Grant Fritchey

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

Chapter 4: Understanding More Complex Query Plans

As we've seen, even relatively simple queries can generate complicated execution plans. Complex T-SQL statements generate ever-expanding execution plans that become more and more time-consuming to decipher. However, just as a large T-SQL statement can be broken down into a series of simple steps, large execution plans are simply extensions of the same simple plans we have already examined, just with more, and different, operators.

In Chapters 2 and 3, we dealt with single statement T-SQL queries. In this chapter, we'll extend that to consider stored procedures, temporary tables, table variables, MERGE statements, and more.

Again, please bear in mind that the plans you see, if you follow along, ...

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