DB2 Joins

pts.
Tags:
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,

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Intravler
    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.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following