Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Plan stability with rule based optimzier
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-lReceived on Fri Feb 11 2005 - 09:27:46 CST
![]() |
![]() |