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
--
http://www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
- References:
- CBO Predicate selectivity
- From: Laimutis Nedzinskas
- Re: CBO Predicate selectivity
- From: Alex Gorbachev
Other related posts:
- » CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » RE: CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » Re: CBO Predicate selectivity
- » RE: CBO Predicate selectivity
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 -- http://www.freelists.org/webpage/oracle-l
- CBO Predicate selectivity
- From: Laimutis Nedzinskas
- Re: CBO Predicate selectivity
- From: Alex Gorbachev