Re: OPT_PARAM
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: LS Cheng <exriscer@xxxxxxxxx>
- Date: Tue, 24 Nov 2009 11:42:48 +0000 (GMT)
Hi
Try something like this
select /*+ opt_param('optimizer_features_enable', '9.2.0')
gather_plan_statistics */
column_name1,count(*)
from table_name
group by column_name
/
select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED LAST'));
--- 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:54
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> 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:
