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
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