Another
common scenario for deadlock
If make a
lot of indexes with same set of columns but sequence is different, can cause
deadlocks between select/update query.
Solution:
Carefully
design indexes for a table, don’t let tuning advisor do it for you.
Reference: