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:-
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
Last activity: Jul 18, 2016, 01:26 PM