Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: density calculation when histograms are involved
Also consult Jonathan Lewis's book Cost-Based Oracle.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alvaro Jose
Fernandez
Sent: Thursday, September 13, 2007 1:56 PM
To: exriscer_at_gmail.com; oracle-l
Subject: RE: density calculation when histograms are involved
Hi Cheng,
Recommend you to read:
1st: Wolfgang's
http://www.centrexcc.com/Histograms%20-%20Myths%20and%20Facts.pdf
2nd: Alberto Dell'Era "Join over Histograms" paper : http://www.adellera.it/investigations/join_over_histograms/JoinOverHisto grams.pdf (covering much more complex cases)
regards.
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 13 2007 - 13:52:35 CDT