Re: Performance of outer join

The only reason to use an outer join is because when inner join does not give the required answer.

So, if the inner join is quicker but wrong, what have you gained?

Wong Chi Chung wrote:

> Hello,
>
> Is outer join slower than the inner join in Oracle? And Why?
>
> Which one is faster?
> 1
> select b.field1, a.field2
> from table1 a, table2 b
> where a.field1(+) = b.field1
>
> 2
> select b.field1, a.field2
> from table1 a, table2 b
> where a.field1 = b.field1
>
> Thanks
>
> Philip
Received on Fri Apr 23 1999 - 21:56:46 CDT