3 ms·
> Actual SQL: joins, subqueries, window functions, query plans And indexes. Many times in my career, adding the right SQL index has solved a serious performanc
by stevoski 4mo ago
> Actual SQL: joins, subqueries, window functions, query plans
And indexes. Many times in my career, adding the right SQL index has solved a serious performance problem.
- fifilura 4mo agoI'd argue that indexes is an implementation detail here and exactly the kind that should not leak into the abstract "thinking about sets and how to combine them". It is valuable and critical in lots of real situations. But it may interfere with the actual learning.