Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locking issues caused by self-referencing foreign key
Obviously the FK must reference a UK or a PK either of which would have
an index used to enforce the constraint so if you perform DML against
the table why would Oracle need an index on the FK column itself? It
would be the PK or UK column value that Oracle would have to verify
against.
HTH -- Mark D Powell -- Received on Tue Apr 19 2005 - 08:38:20 CDT