Re: OPT_PARAM

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Tue, 24 Nov 2009 10:50:45 +0000 (GMT)
Message-ID: <188796.81921.qm_at_web23701.mail.ird.yahoo.com>

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_at_gmail.com> wrote:

From: LS Cheng <exriscer_at_gmail.com>
Subject: Re: OPT_PARAM
To: "hrishy" <hrishys_at_yahoo.co.uk>
Cc: "Dion Cho" <ukja.dion_at_gmail.com>, "Oracle Mailinglist" <oracle-l_at_freelists.org> 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_at_yahoo.co.uk> 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

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

Received on Tue Nov 24 2009 - 04:50:45 CST