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

Re: Indexes and Foreign Keys

From: Mark A <nobody_at_nowhere.com>
Date: Sat, 11 Mar 2006 16:09:26 -0700
Message-ID: <fKidnQReWuI7xY7ZnZ2dnUVZ_s-dnZ2d@comcast.com> 





"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message 
news:Xns978399CB1E357ianalvistahotmailcom_at_70.169.32.36...


>

> Hmmm...

>

> I am/was under the opinion that the PK values can NEVER be changed.

>




Some do, some don't. But even if they did change, it is not always the case 
than index will be used on the child table to enforce the RI, even if an 
index exists. 
Received on Sat Mar 11 2006 - 17:09:26 CST












Original text of this message













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