Re: force hint on complex view; 9.2.0.6
- From: Cosmin Ioan <cosmini@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 16 Feb 2007 08:27:18 -0800 (PST)
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx> 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
Other related posts:
