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 -> Indexes and Foreign Keys

Indexes and Foreign Keys

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sat, 11 Mar 2006 21:30:46 GMT
Message-ID: <akHQf.31462$2O6.26201@newssvr12.news.prodigy.com> 





I've read conflicting thoughts about indexes and foreign keys.



One train of thought has it that you always create indexes for all foreign
keys.  The other train of thought said that not all foreign keys really need
an associated index.



Are there general rules of thumbs to use concerning this?
Received on Sat Mar 11 2006 - 15:30:46 CST












Original text of this message













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