Re: Statistics madness
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 May 2005 17:57:39 +0100
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@xxxxxxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
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:
--
//www.freelists.org/webpage/oracle-l
Other related posts:
