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

Home -> Community -> Mailing Lists -> Oracle-L -> announce: the "Join Over Histograms" paper

announce: the "Join Over Histograms" paper

From: Alberto Dell'Era <alberto.dellera_at_gmail.com>
Date: Wed, 25 Apr 2007 17:43:22 +0200
Message-ID: <4ef2fbf50704250843j7bc93031ldce3650178ee1496@mail.gmail.com>


Dear all,

the paper below presents the results of an investigation about
"the formula used by the Cost Based Optimizer to estimate
the cardinality of an equijoin, when both the columns referenced in the join predicate have histograms collected."

Some practical scenarios (and possible pitfalls) are illustrated as well.

http://www.adellera.it/investigations/join_over_histograms/index.html

I hope that this paper turns out to be useful and of interest.

regards
Alberto Dell'Era

-- 
Alberto Dell'Era

"dulce bellum inexpertis"
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 25 2007 - 10:43:22 CDT

Original text of this message

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