Re: Statistics madness

Things may change in 10.1.0.4

There seems to be some code that
works out how far outside the lo/hi
your query has gone, and adjusts
accordingly.

I happen to be working on it right now.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated April 5th 2005

• Original Message ----- From: "Wolfgang Breitling" <breitliw_at_centrexcc.com> To: <oracle-l_at_freelists.org> Sent: Friday, May 06, 2005 3:41 PM Subject: Re: Statistics madness

The CBO has a number of "sanity" overrides in its "formulas"

1. If your predicate falls outside the lo-hi range it (may) substitute defaults for the selectivity in place of the usual formula

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 06 2005 - 11:55:38 CDT