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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
