RE: force hint on complex view; 9.2.0.6

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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: