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: Cosmin Ioan <cosmini_at_bridge-tech.com>
Date: Fri, 16 Feb 2007 07:18:56 -0800 (PST)
Message-ID: <890226.26477.qm@web60418.mail.yahoo.com>


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
Received on Fri Feb 16 2007 - 09:18:56 CST

Original text of this message

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