Re: Outer Join Tuning ?!?

From: Thomas Jagoditsch <t_j_a_at_geocities.com>
Date: 1997/07/01
Message-ID: <33B8A9E5.1040DD1C@geocities.com>#1/1

This is a multi-part message in MIME format.

--------------C45528AC06D8DD4173A3C978
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Peter McKenzie wrote:
>
> 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'
>
> ;
>

thnx peter. i tried this, and it works fine. but the thing we need ( the example was a bit simplyfied) would look like:

        select a.id
          from a, b
         where a.id = b.id(+) and
               a.name in ( select name from c ... );

and would be hard to handle with an union ;(

some suggest the use of the 'use_concat'-hint (seems the optimizer treats 'or'´s as unions with it), but it doesn´t work for 7.1.4 (maybe someone out there can cross-check this).

wbr.tja...

--------------C45528AC06D8DD4173A3C978
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Thomas Jagoditsch
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Thomas Jagoditsch
n:              Jagoditsch;Thomas
org:            BULL Austria AG
email;internet: t_j_a_at_geocities.com
note:           Home-Page:

=0A=
http://www.geocities.com/ResearchTriangle/3142 x-mozilla-cpt: ;0
x-mozilla-html: TRUE
end: vcard

--------------C45528AC06D8DD4173A3C978-- Received on Tue Jul 01 1997 - 00:00:00 CDT