SQL Fundamentals
Composite Indexes: One Ordering, Not Three
Column order decides which queries a composite index can serve. The rule follows from the structure, and so do the cases where it does not hold.
· 3 min
category
SQL Fundamentals
The language itself: set theory, joins, window functions, CTEs and the mental models behind them.
2 articles
SQL Fundamentals
N+1 Queries: What the ORM Is Actually Doing
One query for the list, then one more for every item in it. The cost is per statement, which is why the profiler shows a fast database and a slow request.
· 3 min