Sample Header Ad - 728x90

Eager spool for update and delete on partitioned table

1 vote
1 answer
606 views

When I update or delete on partition table it shows eager spool in execution plan.

Image for Update query execution plan showing eager spool:- Image for Update query execution plan showing eager spool

I can’t understand why it is doing eager spool only when I am updating or deleting on partition table, same query when I run on non partition table it does not do eager spool.

Asked by Puneet Pathak (11 rep)
Jul 18, 2016, 01:22 PM
Last activity: Jul 18, 2016, 01:26 PM