Skip to main content

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.

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.

DBmarlin Trial