Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: re "CBO - A Configuration Roadmap" -- Histograms on Non-Indexed Columns

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

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 29 Dec 2006 22:45:17 +0800
Message-Id: <7.0.1.0.0.20061229222438.00f70d10@singnet.com.sg>

Christian, Wolfgang, Mladen,

I knew about cardinality driving execution plan if it is used to determine the access method against the table. However, if there was no index on the column, the only access on that column _standalone_ would be a full table scan. {exactly the first paragraph's in the section on Histograms on Non-Indexed columns in Wolfgang's paper , eh ?|
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).

Thank you.

[[BTW : I read Christian's paper after encountering an issue with a query on a single table [no join] where a column in the query IS quite skewed but I thought that Christian's statement was a generalization and began wondering how the Histogram would help in my query {single table , no join}. I guess I was too quick to make that assumption. ]]

So, now, I should also consider skewness in a column if it is in a Join.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 29 2006 - 08:45:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US