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

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 29 Dec 2006 08:07:43 -0700
Message-Id: <20061229150704.0927157C59E@turing.freelists.org>

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

Received on Fri Dec 29 2006 - 09:07:43 CST