Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!

Joins and Lookups

cancel
Showing results for 
Search instead for 
Did you mean: 
hic
Former Employee
Former Employee

Joins and Lookups

Last Update:

Sep 12, 2012 8:01:01 AM

Updated By:

hic

Created date:

Sep 12, 2012 8:01:01 AM

Attachments

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.

Labels (1)
Comments
swuehl
MVP
MVP

Well done, very informative!

Thanks,

Stefan

Not applicable

Awesome insights!

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

This is great !!!

Not applicable

Thank you! very helpful.

jtanajewski
Contributor II
Contributor II

Good info on Lookups.

Not applicable

fair dinkum

khadeer
Specialist
Specialist

Great Post

Not applicable

Informative

Not applicable

Very Nice!

michael_maeuser
Partner Ambassador
Partner Ambassador

Very nice

Version history
Last update:
‎2012-09-12 08:01 AM
Updated by:
Former Employee