Oh, no it does not work that is why I sent this post! Thanks -- LSC On Tue, Nov 24, 2009 at 11:50 AM, hrishy <hrishys@xxxxxxxxxxx> wrote: > oops no sorry that would only make your originaly query work . > > That would run your query below with optimizer_features_enabled to 9.2.0 > > --- On *Tue, 24/11/09, LS Cheng <exriscer@xxxxxxxxx>* wrote: > > > From: LS Cheng <exriscer@xxxxxxxxx> > Subject: Re: OPT_PARAM > To: "hrishy" <hrishys@xxxxxxxxxxx> > Cc: "Dion Cho" <ukja.dion@xxxxxxxxx>, "Oracle Mailinglist" < > oracle-l@xxxxxxxxxxxxx> > Date: Tuesday, 24 November, 2009, 10:35 > > > That will get me a list...? > > Thanks > > > > On Tue, Nov 24, 2009 at 11:33 AM, hrishy > <hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx> > > wrote: > >> Hi >> >> This might just work >> >> ALTER SESSION SET EVENTS '10132 TRACE NAME CONTEXT FOREVER, LEVEL 1'; >> >> SELECT >> /*+ opt_param('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'); >> regards >> Hrishy >> >> >> >> > >