Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Hybrid histograms in 11g ?

Hybrid histograms in 11g ?

From: Milen Kulev <makulev_at_gmx.net>
Date: Fri, 20 Jul 2007 11:19:08 +0200
Message-ID: <20070720091908.21680@gmx.net>


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
Received on Fri Jul 20 2007 - 04:19:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US