Re: re "CBO - A Configuration Roadmap" -- Histograms on Non-Indexed Columns

At 07:45 AM 12/29/2006, Hemant K Chitale wrote:


Christian, Wolfgang, Mladen,


[snip]


Now, from your emails and Christian's short example and
Wolfgang's paper,  I take the explanation that this cardinality would
be used to determine the JOIN method (sort-merge , nested-loop or hash).


and/or the join order


Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com 


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: