Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Performance of outer join

Performance of outer join

From: Wong Chi Chung <cswcc94_at_engsvr.ust.hk>
Date: 23 Apr 1999 17:04:24 GMT
Message-ID: <7fq96o$ovd@ustsu10.ust.hk>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US