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