I believe the strategy is for parameters like that
to be set to false in versions of Oracle where the
code to implement the functionality is still
considered to be beta. It isn't guaranteed to
work properly in your version of Oracle, so
you use it at your own risk.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____England______January 21/23
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
bung ho wrote in message
<567a1b1.0212181807.bb5d8e6_at_posting.google.com>...
>thanks. _push_join_union_view was the one that did the trick, but
>only when it was UNION ALL. i still thought that using the
underyling
>indexes was possible with UNION, but i guess i was wrong. in any
>case, is the desire for this kind of behavior so uncommon that (in v8
>at least) this parameter is false by default?
>
>thanks again.
>
Received on Thu Dec 19 2002 - 02:22:52 CST
