Skip to main content

Index Spool

Short Description

Index spool scans the input rows and builds a nonclustered index on the rows in a hidden object.

Detailed Description

Index spool scans the input rows and builds a non-clustered index on the rows in a hidden object. The object only lives for the time of the query and allows use of the SEEK capabilities of a non-clustered index to output selected rows only.

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