Re: CBO Predicate selectivity

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: gorbyx@xxxxxxxxx
  • Date: Wed, 12 Jul 2006 12:55:20 +0100

There are in fact 2 chapters on selectivity, which ought to serve as a
warning that perhaps the one page metalink note to which you refer is
rather basic. I entirely second Alex's suggestion.

On 7/12/06, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote:
I think it might be useful to look at Cost-Based Oracle Fundamentals
book from Jonathan (chapter on Selectivity) that has nice description
for these issues.

2006/7/12, Laimutis Nedzinskas <Laimutis.Nedzinskas@xxxxxxxxxxxxx>:
> I need any information on how CBO calculates [predicate] selectivity
> which is more precise than in the Note:68992.1


-- Best regards, Alex Gorbachev

http://blog.oracloid.com
--
//www.freelists.org/webpage/oracle-l





--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l


Other related posts: