RE: OPT_PARAM
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "LS Cheng" <exriscer@xxxxxxxxx>
- Date: Wed, 25 Nov 2009 13:28:08 +0100
Hi
> Does anyone know if opt_param hint works with
optimizer_features_enable in
> 11.1.0.7?
IMHO it's not relevant to know whether it's supported or not. In fact,
for that purpose, the hint optimizer_features_enable should be used.
E.g.:
SELECT /*+ 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');
Or I'm missing something obvious?
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008
http://top.antognini.ch
--
//www.freelists.org/webpage/oracle-l
Other related posts:
