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

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

force hint on complex view; 9.2.0.6

From: Cosmin Ioan <cosmini_at_bridge-tech.com>
Date: Fri, 16 Feb 2007 06:02:17 -0800 (PST)
Message-ID: <453124.88870.qm@web60424.mail.yahoo.com>


hello all,
  I have this Ora apps ORDER_HEADER complex view (with many subnested levels of views) that's been hinted (RULE or otherwise), which I'm trying to make it to behave by hinting it to use indexes on it on outside on a query.    

  select /*+ index... */ from order_header    

  technically -- and I've tried it -- hinting views seems to work but only on **simple views with no subviews**..... anything more complex, seems to be ignored.    

  Are there any forcible hints or other techniques to hint these complex views ...other than, of course, breaking apart the views and changing the code ;-)    

  thx,
  Cos

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 16 2007 - 08:02:17 CST

Original text of this message

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