Posted by Mark D Powell on 10/05/23 11:34

Erland, thank you for the reply. I say it a few hours of your post but
got sidetracked on the followup.

About 1/3 of the data in the table was obsolete so we deleted it. The
deadlocks were still occurring. I ran maintenance on the database
during a break period. The update is once again showing as being
single threaded by the query plan and the deadlocks errors have
disappeared.

We have not applied the index because the customer wants to hold off on
changing the customized by the providing vendor application until their
consultant(s) have had time to review the code and come up with a
comprehensive list of changes.

Thanks again. -- Mark D Powell --

[Back to original message]