Re: OPT_PARAM

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: