Re: Plan stability with rule based optimzier
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <JBECKSTROM@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 Feb 2005 09:22:49 -0500
You sure that's all the groups?
----- Original Message -----
From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>;
<ORACLE-L@xxxxxxxxxxxxx>; <oracledba@xxxxxxxxxxx>;
<oracle-rdbms@xxxxxxxxxxxxxxx>
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
