RE: Unnesting Subqueries in an Outline --faking hints

Dave,

You could try to fake the hint in OUTLN.OL$HINTS. I'm testing and NO_UNNEST
is getting translated to NO_FACT() hint. Credit goes for Jonathan Lewis for this (http://www.dbazine.com/oracle/or-articles/jlewis5)

ie: update ol$hints set hint_text = 'NO_UNNEST' where ol_name = 'xxxxx' and hint# = <the_hint_number> ;

regards,

alvaro

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