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

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

Matt Chapman
Towards Data Science
8 min readDec 7, 2023

--

Baby Yoda loves partitions. Do you? Image by Victor Serban on Unsplash

Data Scientists love SQL, but boy do we suck at writing performant queries (maybe because we spent too much time debating whether it’s pronounced “S-Q-L” or “sequel”?).

--

--