Re: Tuning a full outer join

Mikito Harakiri wrote:
>
> Can I suggest using oracle syntax
>
> select --+ use_merge(x y) merge_aj
> *
> from x,y where x.table_name = y.table_name(+)
>
> ? Then plan doesn't seems to have any antijoin.
>

That's a left outer join you've written not a full outer join (hence no need for the anti-join).

Richard Received on Thu Jun 05 2003 - 00:15:17 CDT