Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: lazy spool

About the spool operator

Spool operatorThe spool operator is one of those icons that will show up in a query plan now and then. In this post, we’ll take a closer look at what it does in a query plan, how it affects performance, and what you can do to substitute or eliminate it.

Continue reading About the spool operator
Published 2014-01-05
Categorized as Advanced, SQL Server concepts Tagged eager spool, halloween effect, index spool, lazy spool, operator, query plan, spooling, table spool
sqlsunday.com
Proudly powered by WordPress.