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: 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).
Received on Thu Sep 26 2002 - 19:43:40 CDT
