Re: Enforcing plan via SQL plan baseline
- From: Mihajlo Tekic <mihajlo.tekic@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx
- Date: Thu, 2 Feb 2012 15:21:33 -0600
Have you tried to fix the plan that you want to be used. (Fixed Plan
Baseline)
http://docs.oracle.com/cd/B28359_01/server.111/b28274/optplanmgmt.htm#BABICJBG
~Mihajlo
On Thu, Feb 2, 2012 at 2:56 PM, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote:
> Folks,
> When using SQL plan baseline, is it possible to instruct the optimizer
> to use a baseline that has sub-optimal plan than the one it is currently
> using. For example, a SQL statement, which cannot be altered because it
> is coming out of a COTS application, is currently using an index scan
> and I would like to force it to use FTS. I have tried forcing the
> optimizer to use the SQL plan baseline but it keeps using the index path
> and hence ignoring the plan baseline. Any feedback will be appreciated.
>
>
>
> Thanks
>
> Amir
>
>
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
