Date: Wed, 25 Nov 2009 13:28:08 +0100
> Does anyone know if opt_param hint works with
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
WHERE x = 'S' OR y_date > to_date(:V1, 'MM/DD/YY HH24:MI:SS');
Or I'm missing something obvious?
Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.chReceived on Wed Nov 25 2009 - 06:28:08 CST