Re: outer join

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 06 Feb 2002 07:18:32 GMT
Message-ID: <cN488.31065$ym3.107272@rwcrnsc51.ops.asp.att.net>

You can use a union.
It probably won't speed it up though. Why don't you post the Oracle version,
The query,
the explain plan,
the tkprof.
Jim
"tshen" <tshen01_at_hotmail.com> wrote in message news:0M288.90056$B94.21606527_at_news02.optonline.net...
> hi, guys:
>
> Is there any alternative way to write an outer join "(+)"? thanks.
> because the outer join is very slow. thanks.
>
> Tao
>
>
>
>
Received on Wed Feb 06 2002 - 01:18:32 CST