RE: CBO irregularity
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Jun 2004 11:35:54 -0500
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@xxxxxxxxxxxx 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@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
-----------------------------------------------------------------
Other related posts:
