Home > IT Answers > Database > DB2 Joins
Intravler
0 pts.
 DB2 Joins
DB2 Universal Database
Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID LEFT OUTER JOIN RSTHSTP ON RSINDIP.INICID=RSTHSTP.TVICID Thanks,

Software/Hardware used:
ASKED: November 23, 2005  5:22 PM
UPDATED: November 23, 2005  5:57 PM
RELATED QUESTIONS
Answer Wiki:
There are two parts to your question: (1) Physically: Why should you care? The optimizer will arrange for it to happen in any order it likes. (2) Logically: It will happen as if in the order you specify it. Think of commutability. To some extent, the relationship is commutable. To that extent, you can't say what order it happens in. --- Sheldon Linker sol@linker.com Linker Systems, Inc. www.linkersystems.com 800-315-1174 +1-949-552-1904
Last Wiki Answer Submitted:  November 23, 2005  5:45 pm  by  SheldonLinker   15 pts.
All Answer Wiki Contributors:  SheldonLinker   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The reason for my question is because I’m using two different tools each with a different implementation and I’m getting two different results; that being the number of records selected.

Intravler
 0 pts.