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

1
vote
1answer
34 views

Eager spool for update and delete on partitioned table

When I update or delete on partition table it shows eager spool in execution plan. Image for Update query execution plan showing eager spool:- I can’t understand why it is doing eager spool only ...
0
votes
0answers
38 views

Issues with partitioning

Looking for scale out option for my SQL server database. I have a table that has 15 million rows and it adds 10,000 rows every day. From various options available to scale out I opted for partitioning,...
11
votes
1answer
980 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 ...