Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Table Spool Showplan Operator

The Table Spool operator scans the input and places a copy of each row in a hidden spool table that is stored in the tempdb database and existing only for the lifetime of the query. If the operator is rewound (for example, by a Nested Loops operator) but no rebinding is needed, the spooled data is used instead of rescanning the input.

Table Spool is a physical operator.

Table spool operator iconGraphical execution plan icon

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.