Might as well complete the list with Jonathan's Cost-Based Oracle Fundamentals: http://www.apress.com/book/view/1590596366 At a $25 steal for the eBook, it's been open on my desktop for two solid months now (I'm only on chapter 7!). Rich > 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. > > -- //www.freelists.org/webpage/oracle-l