Row Count Spool
Short Description
The Row Count Spool operator scans the input and stores a count of the rows returned
Detailed Description​
The Row Count Spool operator scans the input and stores a count of the rows returned. This is used when it is important to check for the existence of rows rather than their actual content. This can be used in NESTED LOOPS queries to stop unnecessary iterations. Fabiano Amorim's blog article gives a good example here.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.