Oh, it's not a bug. Oracle told us 10 years ago that RBO was going away. When a feature goes away, it no longer requires either support or regression testing. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Visit www.hotsos.com for curriculum and schedule details... -----Original Message----- From: Mladen Gogala [mailto:mgogala@xxxxxxxxxxxxxxxxxxxx] Sent: Friday, April 22, 2005 3:37 PM To: Cary Millsap Cc: 'Oracle-L' Subject: Re: rm RULE based optimizer != GOOD IDEA Cary Millsap wrote: >But I don't think in 10g you can count on the kernel always returning the >right rows when you use it... > > > Which brings us back to the Lex de Haan's point about regression testing. He sad something to the effect that we have no idea about the way that Oracle Corp. is testing its product when they allow such disastrous bugs to slip through. I believe that Oracle is using faith-based testing algorithms. All we need is to have faith and bugs will be gone. -- Mladen Gogala Oracle DBA Ext. 121 -- //www.freelists.org/webpage/oracle-l