RE: force hint on complex view; 9.2.0.6

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <cosmini@xxxxxxxxxxxxxxx>
  • Date: Fri, 16 Feb 2007 16:17:45 +0100

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


Other related posts: