How Joins Work

periscopedata.com

The SQL join operation is one of the most powerful and commonly used SQL operations, but little attention is paid to how the internal SQL engine breaks down the tasks of join operations.

I'll be the first to admit that this article is really quite boring (it got literally 0 recommends on Feedly), but let me just say that really, truly understanding the query planner and knowing how to read an explain plan are just so unbelievably important in being day-to-day effective. Invest the time to understand this stuff. This post is the best resource I've found on the topic.

Read more...
Linkedin Revue

Want to receive more content like this in your inbox?