Joseph (jc*****@hotmail.com) writes:
hi can anyone tell me if the order of the update staments on multiple
tables can have an effect on deadlocks on a transactions.
for examples if i have a
dog -> dogid colorid breedid name
color-> colorid color
breed-> breedid breed
would it make any difference if i update the breed table before
updating the dog table?
Yes, the order of the update statement has importance, as far that if
different processes updates tables in different order, the risks for
a deadlock increases.
I'm afraid that I don't understand your example, so I cannot comment
on it particularly.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp