Deadlock Question

From: <wagen123_at_yahoo.com>
Date: 1 Jun 2005 11:19:32 -0700
Message-ID: <1117649972.235691.272690@g47g2000cwa.googlegroups.com>

Hi,

Quote fron Steve Adams website - "you need indexes on all the foreign key columns. Otherwise, you need table locks to be disabled on any table that is missing a foreign key index"

Assume that table X1 references to X2 and X2 references to X3 and so on. X1 --> X2 --> X3 --> ... --> Xn-1 --> Xn where X1 is a "lowest child" table.

Can anyone help me simulate a deadlock if the foreign keys are NOT indexed?

Thanks in advance for any help.

wagen Received on Wed Jun 01 2005 - 13:19:32 CDT