How To Write Better Queries

www.datacamp.com

SQL optimization is such a critical topic, and one that too few data professionals go deep on. If you're not familiar with how a query optimizer works, how to read an explain plan, or what linear time is, this article is a great getting started guide. Share this post with your colleagues who are bogging down your Redshift cluster 😉

Note that much of this post was written in the context of a traditional relational engine like MySQL. The core concepts are very relevant for modern analytic databases although the specific recommendations are somewhat less applicable.

Read more...
Linkedin

Want to receive more content like this in your inbox?