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

Home -> Community -> Usenet -> c.d.o.misc -> Foreign Key and Index

Foreign Key and Index

From: Jaret Lafoudravecmonhai <nospam_at_nospam.com>
Date: Thu, 1 Aug 2002 10:41:20 +0200
Message-ID: <aiarlp$17p$1@reader1.imaginet.fr> 





Hello,



I must create some indexes on foreign keys to avoid some locing problems.



Does the column indexes must be exactly the same as FK (exactly the same
column, not more and same order) ? I've got a lot of existing index (PK and
other) including the FK column (but not the same order and more columns),
and i don't want to make redundancy.




Ludo
Received on Thu Aug 01 2002 - 03:41:20 CDT












Original text of this message













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