From oracle-l-bounce@freelists.org Mon Jun 7 14:32:39 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i57JWEl00362 for ; Mon, 7 Jun 2004 14:32:24 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i57JW3600336 for ; Mon, 7 Jun 2004 14:32:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 160FF72C82E; Mon, 7 Jun 2004 14:17:58 -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 09285-03; Mon, 7 Jun 2004 14:17:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3DD3972C770; Mon, 7 Jun 2004 14:17:57 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 07 Jun 2004 14:16:38 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5C1E972C6CD for ; Mon, 7 Jun 2004 14:16:38 -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 08173-79 for ; Mon, 7 Jun 2004 14:16:38 -0500 (EST) Received: from exchange-slc.ut.ovid.com (excluster-slc1.ut.ovid.com [198.242.51.242]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E883A72C6BC for ; Mon, 7 Jun 2004 14:16:37 -0500 (EST) Received: by exchange-slc.ut.ovid.com with Internet Mail Service (5.5.2657.72) id ; Mon, 7 Jun 2004 13:35:41 -0600 Message-ID: <555F2B7B278B5348A28F665E6B0E43A40841D875@exchange-slc.ut.ovid.com> From: Rick Stephenson To: oracle-l@freelists.org Subject: CBO irregularity Date: Mon, 7 Jun 2004 13:35:38 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C44CC6.9C6F9350" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2149 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: RStephenson@Ovid.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C44CC6.9C6F9350 Content-Type: text/plain The CBO has been nothing short of a pain in the butt to me. Going from Development to QA to a live environment achieves unexpected results. It seems that you never know what you are going to get when it comes to an execution plan. The developers run Oracle on their Windows box and the execution path is one way, but when it gets moved to a QA environment it chooses another way. At least with the RULE base optimizer you know what you are going to get. Sometimes I think I am the only one with this problem. How do you work this? Do you always use hints, do you use stored outlines....? Thanks, Rick Stephenson ------_=_NextPart_001_01C44CC6.9C6F9350 Content-Type: text/html

The CBO has been nothing short of a pain in the butt to me. Going from Development to QA to a live environment achieves unexpected results. It seems that you never know what you are going to get when it comes to an execution plan. The developers run Oracle on their Windows box and the execution path is one way, but when it gets moved to a QA environment it chooses another way. At least with the RULE base optimizer you know what you are going to get.

Sometimes I think I am the only one with this problem. How do you work this? Do you always use hints, do you use stored outlines….?

Thanks,

Rick Stephenson

------_=_NextPart_001_01C44CC6.9C6F9350-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------