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: Understanding histograms

Re: Understanding histograms

From: Anurag Varma <avoracle_at_gmail.com>
Date: 14 Mar 2006 15:44:07 -0800
Message-ID: <1142374412.350865.276560@v46g2000cwv.googlegroups.com> 






What oracle version??



Oracle should not have generated the histogram for the unique column
you note. I see that at least 9.2.0.5 had a bug (3929552) where it did
so.



Most likely you are hitting a bug.



Patch! or try using "AUTO"



Anurag
Received on Tue Mar 14 2006 - 17:44:07 CST












Original text of this message













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