RE: Deadlocks on lack of Foreign key indexes ...

Jared, Thank You .....

Tom Kytes book .... pages 108 to 111 goes into this. I will continue to follow this advice.

Mike

-----Original Message-----
Sent: Friday, September 27, 2002 8:43 AM To: Multiple recipients of list ORACLE-L

I always use indexes on FK's.

If it's a table with many updates, it needs them to avoid locks on the table.

If the table doesn't have many updates, it's not really necessary, but it doesn't hurt either, and that way I don't have to figure out if it's busy enough to warrant the index. :)

Jared

On Thursday 26 September 2002 17:43, Johnson, Michael wrote:
> Does anyone consider it essential to put indexes
> on Foreign Keys or is it just an option to safeguard
> against the rare possiblity of a deadlock ?
> Is this possibility real and have you seen it happen ?
> I am one who does not want to create a foreign index
> as their is already one wih a leading column which
> makes this foreign key index redundant.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson, Michael 
  INET: Michael.Johnson_at_oln-afmc.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).