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.