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 Corporationwww.centrexcc.com
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System.For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
-- //www.freelists.org/webpage/oracle-l