Re: Outer Join Tuning ?!?

From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1997/06/30
Message-ID: <5p7hob$53$1@marri.bs.wa.gov.au>#1/1

Try this :-

 select a.id

       from a, b
        where a.id = b.id(+) and
              a.name = 'A'

union all

      select a.id
       from a, b
        where a.id = b.id(+) and
              a.name = 'B'

;

 Thomas Jagoditsch wrote in article <33B0FD25.1E0BEB53_at_geocities.com>...
>hi !
>
>following SQL-Select seems to be diffcult to tune>Examples:
>
>1.) outer table join with or:
>
> explain plan for
> select a.id
> from a, b
> where a.id = b.id(+) and
> a.name in ('A','B');
>
Received on Mon Jun 30 1997 - 00:00:00 CDT