Tag: Index
3 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].
-
Reading MySQL EXPLAIN: Index Design, Statistics and Slow Query Fixes
How to read MySQL EXPLAIN and EXPLAIN ANALYZE output, design composite and covering indexes, refresh statistics with ANALYZE TABLE and histograms, and diagnose the queries that still ignore your index.
-
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.