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 2: Reading Graphical Execution Plans for Basic Queries

The aim of this chapter is to enable you to interpret basic graphical execution plans, in other words, execution plans for simple SELECT, UPDATE, INSERT or DELETE queries, with only a few joins and no advanced functions or hints. In order to do this, we'll cover the graphical execution plan topics below.

  • Operators – Introduced in the last chapter – now you'll see more.
  • Joins – What's a relational system without the joins between tables?
  • WHERE clause – You need to filter your data and it does affect the execution plans.
  • Aggregates – How grouping data changes execution plans.
  • Execution plans for data modificationsINSERT, UPDATE and DELETE statements.

The Language of Graphical ...

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