Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: force hint on complex view; 9.2.0.6

RE: force hint on complex view; 9.2.0.6

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 16 Feb 2007 16:17:45 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF9CC582@MSXVS04.trivadis.com> 





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


Received on Fri Feb 16 2007 - 09:17:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US