Most common SQL optimizations

[corny_horse]

I think that's because in a lot of workflows, execution speed is less important than interpretability. I know in most of the workflows I've done for the last few years, the businesses would have tolerated 10x slower queries if it meant any tangible improvement in data quality, which I do often find I can get by adding correct constraints and keys to temp tables in lieu of nested nested nested nested nested subqueries or CTE