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

0
votes
0answers
43 views

How to avoid an Index Spool [closed]

I have a scenario wherein my SQL Server 2012 production server is generating an execution plan using Index Spool to read a billion rows and to filter 40. This is a complex query being generated ...
10
votes
1answer
948 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 ...