Have you tried the PUSH_PRED hint.
Its action is to push join predicates into
views, so may do what you want when
combined with the ORDERED USE_NL(c)
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Robert Massey wrote in message
<0c1qvtchevarint62pburn5t0gs43sho53_at_4ax.com>...
>On Thu, 22 Nov 2001 06:20:31 +0100, Sybrand Bakker, wrote:
>
>However, you are correct about the usage of the USE_NL hint. The inner
>table (child, in this case) should be specified. So, the query becomes:
>
>Select --+ USE_NL(c) ORDERED
> p.pfield1,
> p.pfield2,
>
Received on Thu Nov 22 2001 - 09:37:46 CST
