RE: Question about SQL joins & performance

Hi Charles,

You are right, that's the only difference.

I used Visual Explain in Navigator, but it seems that the second statement 
that is run (irrespective of which of the two it is) is faster.

That's why I also assume that it doesn't matter.

But I was looking for a confirmation of that assumption.

Thanks,

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----




"Wilt, Charles" <CWilt@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
17/01/2005 14:53
Please respond to Midrange Systems Technical Discussion

 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: Question about SQL joins & performance


Peter,

Looks like the only difference is in the order of the join keys correct?

 left outer join pdic52pf on 
(pdmnbr52=pdmnbr19 and vernbr52=vernbr19)

vs.

 left outer join pdic52pf on 
(pdmnbr19=pdmnbr52 and vernbr19=vernbr52)


I don't believe it matters.  You could use Visual Explain in iSeries 
Navigator to see for sure.  One way to start VE is through the "Run SQL 
Scripts" function.

HTH,
 

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121