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@xxxxxxxxxxxxxxxxx www.credit-suisse.com ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alvaro Jose Fernandez Sent: Thursday, September 13, 2007 1:56 PM To: exriscer@xxxxxxxxx; 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. ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==============================================================================