I am having deadlock problems in writing to a table. Admin mentioned
sthg about the indices, but I did not understand it clearly. The issue
happens when two different processes try to write to the table. They
are run with 2 different update_date at the same time.


CREATE INDEX I1_table
ON dbo.table(ID)
GO
CREATE UNIQUE INDEX IU_table
ON dbo.table(model_id, update_date, ID)
GO
CREATE CLUSTERED INDEX IC_table
ON dbo.table(update_date)
WITH allow_dup_row
GO

I have an update statement at end of the procedure which updates
columns in the table with specific model_id and update_date, and
procedure deadlocks. Could you tell me why any of my index
constructions could be causing this?

Thanks