Re: OPT_PARAM
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: exriscer@xxxxxxxxx
- 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@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> 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
Other related posts:
