Press "Enter" to skip to content

Tuning a Slow Query in SQL Server: Query and Index Updates

Erik Darling gives us an overview:

We can surmise a few things from this plan:

  • If there are good indexes, SQL Server isn’t using them
  • That hash spill is some extra kind of bad news
  • Spools remain a reliable indicator that something is terribly wrong

Okay, so I’m kidding a bit on the last point. Sorta.

Read on for the scenario and how Erik would handle this case.