4 articles tagged Databases.
Compound index ordering, the ESR rule, covered queries, and how to read explain() output to confirm an index is actually being used.
The TweakPad Team
The embed-versus-reference decision, the 16 MB document limit, and five schema patterns that solve the problems normalisation would have solved in SQL.
The TweakPad Team
How to diagnose a slow query with EXPLAIN ANALYZE, the index rules that matter, and the eight query patterns that defeat indexes.
The TweakPad Team
What each join type returns, why LEFT JOIN with a WHERE clause silently becomes an INNER JOIN, and how row multiplication inflates your aggregates.
The TweakPad Team