RE: Histograms - SIZE clause & num

From: Charudatta Joshi <joshic_at_mahindrabt.com>
Date: Mon, 2 Aug 2004 20:39:38 +0530
Message-ID: <MHEAIPLKCACENJKNJIALAEOOCDAA.joshic@mahindrabt.com>

Hi,

It was a 9.2.0.3 database. Sorry my mistake..

Thanks & regards,
Charu.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wolfgang Breitling Sent: Monday, August 02, 2004 8:13 PM
To: oracle-l_at_freelists.org
Subject: RE: Histograms - SIZE clause & num_buckets anomaly

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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


*********************************************************
Disclaimer:          

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Aug 02 2004 - 10:06:13 CDT