Re: force hint on complex view; 9.2.0.6

my bad; pls disregard;
yeah, between global hints and NO_INDEX, I should be able to do some serious Yoga SQL ;-)

thx all,
Cos

Cosmin Ioan <cosmini_at_bridge-tech.com> wrote: excellent, that's **part** of the answer I was looking for! thanks Mark/Christian.

I am however looking for options to
--**override** (or turn off) (some of) the existing hints (whether RULE or otherwise), and/or **complement** them with more. Is something like this possible?   

thx much,
Cos

"Mark J. Bobak" <mark.bobak_at_il.proquest.com> wrote: Cosmin,

I think what you want are global hints:
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#6298

Hope that helps,

-Mark
On Fri, 2007-02-16 at 06:02 -0800, Cosmin Ioan wrote:
> 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