In article <1117748644.429200.59330_at_g14g2000cwa.googlegroups.com>,
wagen123_at_yahoo.com says...
>
>J. Lewis: Thank You.
>Tom Kyte: Thanks for correcting me. To prevent full table scans on the
>child table and blocking scenarios (as you described), will creating
>indexes on the foreign keys PREVENT deadlocks. I am still not clear
>about this. Can you help me simulate a deadlock if the foreign keys are
>NOT indexed?
>
>Thanks very much.
>
indexing the foreign keys prevents the lock of the child table when you update
the parent primary key, or delete from the parent.
--
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation
Received on Thu Jun 02 2005 - 17:29:23 CDT
