The index spool execution plan operator optimizes access to an intermediate result set by building a temporary nonclustered index in tempdb.

learn more… | top users | synonyms

9
votes
1answer
550 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 ...