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 -> outer vs. inner join

outer vs. inner join

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Wed, 3 Apr 2002 20:42:25 +0200
Message-ID: <a8fibi$rujdo$1@ID-54600.news.dfncis.de>


the question is: what is better for read performance: outer or inner joining two tables:

T1 (c1, c2, c3, r1)
T2 (c1, c2, c3)

c1 are the primary keys, T1 and T1 join on r1

in the case that r1 has a null value - an inner join does not return rows - so i have to use an outer join because i wanna always see the T1 rows

would it be better for performance when i insert a dummy row into T2 (e.g. -1, null, null) and reference this dummy row always from T1 when the would be normally be a null value - now i can use an inner join Received on Wed Apr 03 2002 - 12:42:25 CST

Original text of this message

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