Re: join

From: Ed Prochak <prochak_at_my-deja.com>
Date: Mon, 01 Nov 1999 17:21:10 GMT
Message-ID: <7vki61$a46$1@nnrp1.deja.com>

Have you tested the UNION query to see if it really is "too long"? If the JOIN query takes 40seconds, maybe you need to consider speeding it up. Do you have indices on the ID field in each table? Have you ANALYZED the tables before the query? (How big are these tables that a simple join on the key takes so long?)

Try running an EXPLAIN PLAN or TRACE and see where your bottleneck is.

In article <7vfc7g$b1o$1_at_news01.btx.dtag.de>, "itd: Joerg Leute" <jl_at_itdesign.de> wrote:
> Hi everybody
>
> Suppose i have two tables
>
> Table1:
>
> ID Name
> 1 Joe
>
> Table2:
>
> Table1_ID LastName
> 1 Jackson
>
> The normal join results in
>
> ID Name Lastname
> 1 Joe Jackson
>
> Is there any way to have a result like this....
>
> ID Name Lastname
> 1 Joe
> 1 Joe Jackson
>
> ...withoug using a UNION query. This example is very simplified - the
real
> query takes about 40 seconds - a UNION would last too long.
>
> Thanks for your help
>
> Joerg
>
>

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support 440-498-3700 magic_at_interfacefamily.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 01 1999 - 11:21:10 CST