From oracle-l-bounce@freelists.org Fri Apr 22 17:42:24 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3MMgNDv014135 for ; Fri, 22 Apr 2005 17:42:23 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3MMgN4Z014131 for ; Fri, 22 Apr 2005 17:42:23 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ED91B186257; Fri, 22 Apr 2005 16:40:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29047-05; Fri, 22 Apr 2005 16:40:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4FC4B1862C8; Fri, 22 Apr 2005 16:40:01 -0500 (EST) Date: Fri, 22 Apr 2005 16:36:12 -0500 From: "Cary Millsap" To: "'Mladen Gogala'" Cc: "'Oracle-L'" Message-ID: <2066.38621114205744.hotsos01.hotsos.com@MHS> In-Reply-To: <4269604F.7070603@allegientsystems.com> Subject: RE: rm RULE based optimizer != GOOD IDEA x-scalix-Hops: 1 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcVHeotiEQGsUFA8RrSiX5mlfPDZ5AACJPyA MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: 8bit X-archive-position: 18886 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Cary.Millsap@hotsos.com Precedence: normal Reply-To: Cary.Millsap@hotsos.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 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@allegientsystems.com] 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 -- http://www.freelists.org/webpage/oracle-l