Hi Axr2,

Thanks for your reply, Yes they are waiting for Indexes blocks. There are multiple indexes on this table, each time it is deadlocked it is referring to a different Index. I don't know if there are any problems with indexes. I am trying to rebuild all the indexes and give it a try.

Hi Tamil,

This table has FK references and they are indexed as well and thanks for your response.

Thanks,
Prasad.