Hybrid histograms in 11g ?
- From: "Milen Kulev" <makulev@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Jul 2007 11:19:08 +0200
Hi listers,
I have just read the Oracle White paper:
http://www.oracle.com/technology/products/database/oracle11g/pdf/performance-11g-whitepaper.pdf
On page 11 there is a following statement:
"
...
ding better information to the CBO by correlating statistics, such as Number of
Distinct Values (NDV) and histograms, on multiple column
...
"
Are these so called "Hybrid histograms" ?
If yes, is there still a constraint of 254 buckets per histogram?
Any ideas, experiences from "early birds" in this list ?
Best Regrads.
Milen
--
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kanns mit allen: http://www.gmx.net/de/go/multimessenger
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: Hybrid histograms in 11g ?
- From: Bobak, Mark
Other related posts:
- » Hybrid histograms in 11g ?
- » RE: Hybrid histograms in 11g ?
- » RE: Hybrid histograms in 11g ?
- » RE: Hybrid histograms in 11g ?
- » RE: Hybrid histograms in 11g ?
- » RE: Hybrid histograms in 11g ?
- RE: Hybrid histograms in 11g ?
- From: Bobak, Mark