Re: Enforcing plan via SQL plan baseline

From: Jared Still <>
Date: Mon, 6 Feb 2012 11:47:16 -0800
Message-ID: <>

On Mon, Feb 6, 2012 at 11:20 AM, Wolfgang Breitling <>wrote:
> And you disabled the original (unhinted) plan? Did you follow the steps in
> Maria's blog (**optimizer/tags/sql_plan_**
> management <>)? I haven't had a problem substituting a different plan for a sql. My
> problem is that Peoplesoft has too many sql where this technique is not
> applicable ( because they use literals in sql ).

Actually I did use Maria's blog as a reference.

But, I don't think I disabled the original plan.

Thanks Wolfgang, that's probably the step I was missing.


Received on Mon Feb 06 2012 - 13:47:16 CST

Original text of this message