Add One Line of SQL to Optimise Your BigQuery Tables

Clustering: A simple way to group similar rows and prevent unnecessary data processing

Published in

Towards Data Science

5 min readDec 8, 2023

--

In my previous article, I explained how to optimise SQL queries using partitioning:

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

towardsdatascience.com

Matt Chapman

Written by Matt Chapman

Writer for

Towards Data Science

Data Scientist based in Oxford, UK. Learn SQL at the-SQL-gym.com or get my portfolio template at MakePage.org

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams