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: CBO rows estimate way out in 2 table join - what to do?

Re: CBO rows estimate way out in 2 table join - what to do?

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Mon, 29 Oct 2007 18:54:15 -0000
Message-ID: <1193684055.656654.271790@k79g2000hse.googlegroups.com> 





On Oct 29, 12:43 pm, stephen O'D <stephen.odonn..._at_gmail.com> wrote:



<snip>



> I have played around with histograms on some of the columns, but am

> not getting anywhere fast!

>




Hi Stephen,



Have you tried *not* using histograms?  If you know you always want a
certain access path because you know your data (business data as
Jonathan refers to it in the book you reference), histograms (as
calculated by oracle) could be "messing" you up.



Can you post the execution plan?



HTH,


Steve
Received on Mon Oct 29 2007 - 13:54:15 CDT












Original text of this message













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