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 8: Advanced Topics

In the previous chapters, we have discussed how the optimizer generates execution plans and how to interpret them, and we have examined plans for some moderately complex queries, including most of the common SQL Server objects, such as stored procedures, views, indexes, cursors, and so on. In our discussion of hints, we even walked through some ways in which we could exercise a measure of control over how the optimizer generates an execution plan.

In this chapter, we will take a tour of some of the more advanced topics related to the interpretation and manipulation of execution plans, covering the points below.

  • Large-scale execution plans – How to interpret them.
  • Parallelism – Why you might want to use parallelism, ...

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