Date: Tue, 24 Nov 2009 10:50:45 +0000 (GMT)
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...?
On Tue, Nov 24, 2009 at 11:33 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:
This might just work
ALTER SESSION SET EVENTS '10132 TRACE NAME CONTEXT FOREVER, LEVEL 1';
/*+ opt_param('optimizer_features_enable', '9.2.0') */ x, y, z
WHERE x = 'S' OR y_date > to_date(:V1, 'MM/DD/YY HH24:MI:SS');