Sample Header Ad - 728x90

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? enter image description here
Asked by Yevgeni Grinberg (161 rep)
Dec 22, 2019, 01:17 PM
Last activity: Dec 23, 2019, 12:58 PM