Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: CBO: built-in default selectivity for range scan
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