Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Locking issues caused by self-referencing foreign key

Re: Locking issues caused by self-referencing foreign key

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Apr 2005 06:38:20 -0700
Message-ID: <1113917900.624179.50480@o13g2000cwo.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US