Hi, I'm having a deadlock issue. I noticed that I've 2 queries one doing an update and the other doing an insert,
My table has a cluster index on the ID which is an identity field. The update statement is updating other columns which are not included on the cluster index, however on the execution plan it shows that it will need to do a cluster index update.
What's the reason it could be that the cluster index needs an update if the column itself is not being updated?
Thanks in advance.
View Complete Post