Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Performance of outer join
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 - 12:04:24 CDT