Re: force hint on complex view; 9.2.0.6

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 16 Feb 2007 08:24:59 -0700
Message-Id: <20070216152410.67A8C601366@turing.freelists.org>

What Oracle version? 10g has introduced query block names - either system assigned or named in the sql. Then you can direct hints to a specific query block.

At 07:02 AM 2/16/2007, Cosmin Ioan wrote:
>
>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 ;-)
>

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 16 2007 - 09:24:59 CST