Joins and Lookups

[hic]

This document concerns data modelling and joins

• What is the difference between a join using the join prefix and a join using a SELECT statement?
• When should you join and when shouldn't you? Performance considerations?
• Are there alternatives to joins? (Yes! Applymap!)
• What does the Keep prefix do?

HIC

See also my blog post on the same subject: To Join or not to Join.

[swuehl]

Well done, very informative!

Thanks,

Stefan

[#3]

Awesome insights!

[phaneendra_kunc]

This is great !!!

[#5]

Thank you! very helpful.

[jtanajewski]

Good info on Lookups.

[#7]

fair dinkum

[khadeer]

Great Post

[#9]

Informative

[#10]

Very Nice!

[michael_maeuser]

Very nice