Index Update with Eager Spool and Sort operators in Execution Plan
-1
votes
1
answer
1041
views
After an UPDATE statement on a large table, the execution plan shows updates of indexes (all non-clustered) that include the updated columns.
Before each index update, there is an Eager Spool operator followed by a very costly Sort.
Overall, the updates of the indexes consume about 50% of the execution time.
Is there a way to optimize the indexes and minimize the costs?

Asked by Yevgeni Grinberg
(161 rep)
Dec 22, 2019, 01:17 PM
Last activity: Dec 23, 2019, 12:58 PM
Last activity: Dec 23, 2019, 12:58 PM