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: > > > 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 Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l