From oracle-l-bounce@freelists.org Thu Mar 18 09:35:35 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2IFZZI32742 for ; Thu, 18 Mar 2004 09:35: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 i2IFZUo32710 for ; Thu, 18 Mar 2004 09:35:31 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82D47390FBD; Thu, 18 Mar 2004 10:19:20 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 18 Mar 2004 10:18:14 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ha-smtp1.tiscali.nl (ha-smtp1.tiscali.nl [195.241.76.187]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98F90390BC3 for ; Thu, 18 Mar 2004 10:18:13 -0500 (EST) Received: from LEXLAPTOP (82-168-217-228-bbxl.xdsl.tiscali.nl [82.168.217.228]) by ha-smtp1.tiscali.nl (Postfix) with SMTP id 98E483F54F8 for ; Thu, 18 Mar 2004 16:24:25 +0100 (CET) From: "Lex de Haan" To: Subject: RE: Stored Outlines and Optimizer Mode Date: Thu, 18 Mar 2004 16:24:17 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005B_01C40D05.75D753A0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <20040318150750.56114.qmail@web61108.mail.yahoo.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-archive-position: 1140 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lex.de.haan@naturaljoin.nl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_005B_01C40D05.75D753A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit no, they don't -- stored outlines are based on the mechanism of hints, and hints kick in the CBO ... Cheers, Lex. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Paula Winkler Sent: donderdag 18 maart 2004 16:08 To: oracle-l@freelists.org Subject: Stored Outlines and Optimizer Mode Hi listers, I've used stored outlines with CBO. Do you know if stored outlines work with RBO? The database is Oracle8i. Thank you in advance for your help! - Paula W. Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam ------=_NextPart_000_005B_01C40D05.75D753A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
no,=20 they don't -- stored outlines are based on the mechanism of hints, and = hints=20 kick in the CBO ...
 
Cheers,
Lex.
-----Original Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On=20 Behalf Of Paula Winkler
Sent: donderdag 18 maart 2004=20 16:08
To: oracle-l@freelists.org
Subject: Stored = Outlines=20 and Optimizer Mode

Hi listers,
 
I've used stored outlines with CBO.  Do you know if stored = outlines=20 work with RBO?  The database is Oracle8i.
 
Thank you in advance for your help!
 
- Paula W.

Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, = less=20 spam

------=_NextPart_000_005B_01C40D05.75D753A0-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------