At 07:41 AM 8/2/2004, you wrote: >Thanks Wolfgang, > >Yes, doubling the size parameter created frequency based histograms. Seems >very weird though. BTW, I am seeing exactly the same behaviour in 8.1.7.4 >environment. I have never seen that in Oracle 8i. >And unless one is aware of this quirk, this creation of height-based >histograms instead of f.b. histograms will affect the query execution plans >adversely, isn't it? Very possibly. Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------