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 -> Does Ref. Integrity help CBO ?

Does Ref. Integrity help CBO ?

From: klabu <nosuchuser_at_gmail_dot_com>
Date: Wed, 25 Oct 2006 12:53:14 -0400
Message-ID: <12jv5jrnp81rm0e@corp.supernews.com> 





10gR2



Does Ref. Integrity help CBO ?


or maybe my Q should be: Does Statistics take RI into consideration ?



So if say joining n tables....


Does the fact that these tables have RI amongst them "help" CBO do a 
"better" job


than if they just have PKs defined ?




thanks, hope i'm making sense, I tried ;) 
Received on Wed Oct 25 2006 - 11:53:14 CDT












Original text of this message













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