Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Plan stability with rule based optimzier

Re: Plan stability with rule based optimzier

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Fri, 11 Feb 2005 09:22:49 -0500
Message-ID: <BAY20-DAV825A99B6EB7AB9E9F7288A6770@phx.gbl>


You sure that's all the groups?
----- Original Message -----
From: "Jeffrey Beckstrom" <JBECKSTROM_at_gcrta.org> To: <oracle-l_at_freelists.org>; <oracle-db-l_at_Groups.ITtoolbox.com>; <ORACLE-L_at_IC.SUNYSB.EDU>; <oracledba_at_LazyDBA.com>; <oracle-rdbms_at_yahoogroups.com>
Sent: Friday, February 11, 2005 9:09 AM
Subject: Plan stability with rule based optimzier

> Before going to far, I want to make sure this will work.
>
> Our database is running with RULE set at the database level. We would
> like to tune an SQL statement in a third party application by using a
> stored outline. For the sql in question, we are going to add a "Choose"
> database hint.
>
> Is it possible to use stored outlines if the database is running in
> RULE mode?
>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 11 2005 - 09:27:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US