Re: Statistics madness

Correct,

I have n1 with values from 0 to 9
100 rows of each.

select where n1 = 10        card = 89
select where n1 = 11        card = 78
select where n1 = 12        card = 67

select where n1 = 18        card = 1

10.1.0.4 - I don't think it did this on 10.1.0.2     

    I demo'd Oracle 11! with attitude on Tuesday     Looks like we have 10g with existential angst

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: <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org> Sent: Friday, May 06, 2005 5:46 PM Subject: Re: Statistics madness

Let me see if I get this right. The optimizer now is saying "according to all I know, what you are asking for doesn't exist. But now let me figure out a degree of 'does not exist'"

Jonathan Lewis wrote:

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 06 2005 - 13:01:58 CDT