How Eager Index Spools Cause Performance Problems
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
Related Posts
- How To Write SQL Server Queries Correctly: Literally Everything You Need To Know About OUTPUT
- How To Write SQL Server Queries Correctly: Literally Everything You Need To Know About CTEs
- How To Write SQL Server Queries Correctly: Case Expressions
- How To Write SQL Server Queries Correctly: Joins With OR Clauses Part 2
I followed along and took it one step further, indexing the Users table as you mentioned:
CREATE index ix_users_rep on dbo.users (reputation, id) include (displayname) with (maxdop=8, sort_in_tempdb = on);
That further reduced my query time from 12 ms to effectively 0 ms. This has been a great series, thanks for publishing it.
Very good! Thanks for watching, and for the kind words.