Use the Partitions, Luke! A Simple and Proven Way to Optimise Your SQL Queries | Towards Data Science

If you’ve ever written an SQL query that takes ages to run, this is the article for you