Re: OPT_PARAM

I did not know optimizer_features_enable can be used as a hint. I will try it and see how it works

Thanks!

--
LSC


On Wed, Nov 25, 2009 at 1:28 PM, Christian Antognini <
Christian.Antognini_at_trivadis.com> wrote:



> Hi

>

> > Does anyone know if opt_param hint works with

> optimizer_features_enable in

> > 11.1.0.7?

>

> IMHO it's not relevant to know whether it's supported or not. In fact,

> for that purpose, the hint optimizer_features_enable should be used.

> E.g.:

>

> SELECT /*+ optimizer_features_enable('9.2.0') */ x, y, z

>  FROM v_lsc

> WHERE x = 'S' OR y_date > to_date(:V1, 'MM/DD/YY HH24:MI:SS');

>

>

> Or I'm missing something obvious?

>

>

> HTH

> Chris Antognini

>

> Troubleshooting Oracle Performance, Apress 2008

> http://top.antognini.ch

>

>

>


--
http://www.freelists.org/webpage/oracle-l