Amit > don't you mean /*+ opt_param('optimizer_features_enabled', '9.0.1') */ ? No. I meant what I wrote, i.e.: /*+ optimizer_features_enable('9.0.1') */ Also notice that the name of the parameter in your example is wrong. There's no "d"... HTH Chris -- //www.freelists.org/webpage/oracle-l