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 -> Foreign key constraints

Foreign key constraints

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Fri, 18 Jun 1999 08:49:54 -0400
Message-ID: <376A4072.D3DA4BB8@lucent.com> 





Question: If a foreign key constraint is created for a column in a
table, is it required that there be an index on that column? One book I
read suggested that if there isn't an index for the column then there
may be locking problems when updates occur.



Ken

Received on Fri Jun 18 1999 - 07:49:54 CDT












Original text of this message













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