From oracle-l-bounce@freelists.org Wed Feb 25 11:36:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1PHaZG16379 for ; Wed, 25 Feb 2004 11:36:35 -0600 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 i1PHaYo16374 for ; Wed, 25 Feb 2004 11:36:34 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB3D7395576; Wed, 25 Feb 2004 12:37:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 25 Feb 2004 12:36:45 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smtp3.mmedia.is (smtp3.mmedia.is [217.151.160.13]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A7FC394E6E for ; Wed, 25 Feb 2004 12:36:42 -0500 (EST) Received: from smtp.mmedia.is (pop3.mmedia.is [217.151.160.9]) by smtp3.mmedia.is (8.12.10/8.12.10/1.0.1) with ESMTP id i1PHdQ3Z020446 for ; Wed, 25 Feb 2004 17:39:26 GMT Received: from numenor (adsl176-198.as.mmedia.is [217.151.176.198]) by smtp.mmedia.is (8.11.7/1.0.0) with SMTP id i1PHdO326311 for ; Wed, 25 Feb 2004 17:39:24 GMT Message-ID: <007501c3fbc6$f2164cf0$c6b097d9@numenor> From: "Gudmundur Josepsson" To: Subject: Stored outlines Date: Wed, 25 Feb 2004 17:43:57 -0000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0072_01C3FBC6.F1C546C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 1932 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gbj@index.is Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_0072_01C3FBC6.F1C546C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Is anybody using stored outlines in=20 production? There has been some talk about outlines being a great = tool to=20 optimize SQL statements without having access to the source, which to me = seems=20 to be the best reason to use them. Others have said that using = stored=20 outlines interferes with the CBO and that you'd be just as well off = with=20 the RBO.

Any thoughts?

Gudmundur

------=_NextPart_000_0072_01C3FBC6.F1C546C0-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------