RE: CBO irregularity

On "collect histograms", any thoughts on using the AUTO keyword when specifying the number of buckets?

(Sorry...a little behind here -- migrated to 9.2.0.5 this weekend)

TIA,
Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----

Sent: Monday, June 07, 2004 3:09 PM
Subject: RE: CBO irregularity

• Collect histograms for skewed data. For example, if you tell CBO that an attribute with domain cardinality 2 has uniformly distributed values, then CBO will make dumb decisions if the real distribution is 99/1 instead of 50/50.

  ---

  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

  ---