Hi Cosmin > I'm trying to make it to behave by hinting > it to use indexes on it on outside on a query. Did you try with global hints? http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsr ef.htm#6257 If not, that's your problem. Probably. HTH Chris -- //www.freelists.org/webpage/oracle-l