RE: OPT_PARAM

> 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

--
http://www.freelists.org/webpage/oracle-l