The index spool execution plan operator optimizes access to an intermediate result set by building a temporary nonclustered index in tempdb.
8
votes
1answer
316 views
Forcing an index spool
I know its something that should be avoided for performance reasons, but am trying to show a condition where it appears as a demo on how to make sure it does not appear.
However, I end up with a ...
