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: Foreign key constraint removes need for index?

Re: Foreign key constraint removes need for index?

From: <frank.van.bortel_at_gmail.com>
Date: 14 Sep 2006 00:44:43 -0700
Message-ID: <1158219883.850826.37930@i42g2000cwa.googlegroups.com> 






johnhurt_at_gmail.com schreef:



> If column A has a foreign key constraint with a parent table, then do I

> need to explicitly add an index on column A for performance in queries?




I would, too. Apart from the discussion David pointed
you to, it was/is common practise according to CDM.
Not that that means anything of course :)



CDM=Custom Development Methodology (by oracle)
Received on Thu Sep 14 2006 - 02:44:43 CDT












Original text of this message













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