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: CBO: built-in default selectivity for range scan

Re: CBO: built-in default selectivity for range scan

From: Paul Parker <paul_g_parker_at_yahoo.com>
Date: Fri, 10 Nov 2000 08:33:08 -0800 (PST)
Message-Id: <10676.121733@fatcity.com>


Hi Ed,

Whilst I haven't confirmed this with any tests, the doc from an internals course which I took says that the default selectivity for
bounded/unbounded range scan for bind variables is 5%.

Let me know if you find anything to the contrary.

Paul



Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Received on Fri Nov 10 2000 - 10:33:08 CST

Original text of this message

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