This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
what's the meaning of TABLE SPOOL operator Rewind and Rebind ?
Additional SQL Server features and topics not covered by specific categories
Answer accepted by question author
I went to http://www.google.com, don't know if you have heard of this site? Anyway, in the search box, I entered
TABLE SPOOL rewind rebind
There were some hits from people that I know as knowledgeable. For instance https://www.scarydba.com/2011/06/15/rebind-and-rewind-in-execution-plans/
"The difference between a rebind and rewind has to do with the values that are part of the loop join itself. As those values change, as different data is accessed in the outer part of the loop, you see rebinds. When those values aren’t changed then you’ll see a rewind. You’ll also see that the aggregation of these values is equal to the number of rows in the outer join."
ok and . thanks . and I think I know some it's idea .