Tag: query optimization
2 posts
-
Database Query Optimization from C++: Index Selection, EXPLAIN Plans and Statistics
C++ query optimization: index selection, EXPLAIN plans, statistics, cost models, and production patterns [#49-3].
-
Speeding Up Slow SQL: Index Design, Reading EXPLAIN, N+1 Queries, Joins and Subqueries
How B-Tree indexes work, how to order composite index columns, how to read EXPLAIN, why an existing index sometimes goes unused (functions, leading wildcards, OR, type conversion), fixing N+1 queries, and a find-fix-measure workflow for MySQL and PostgreSQL.