Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> force hint on complex view; 9.2.0.6
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-lReceived on Fri Feb 16 2007 - 08:02:17 CST
![]() |
![]() |