Explain Extended
by Alex Bolenok · Explain Extended
Long-running blog by Quassnoi devoted to SQL query performance, dissecting individual problems across MySQL, PostgreSQL, SQL Server and Oracle with execution plans, timings and rewritten queries. Shows why an optimizer picks a plan and how rewrites change it.
More resources on Database Performance
use-the-index-luke.com
A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases.
PG Mustard Blog
Michael Christofides' blog at pgMustard on PostgreSQL query performance: reading EXPLAIN output and query plans, indexing strategy, pg_stat_statements, and changes in new Postgres releases, with practical guidance for diagnosing and fixing slow queries.
Percona Blog
Engineering blog from Percona, a MySQL, PostgreSQL and MongoDB support vendor. Posts benchmark storage engines, dissect replication and failover behaviour, and explain version changes, giving practitioners evidence-based guidance on tuning and operating open-source databases in production.
High Performance MySQL
A practical guide to MySQL performance from Percona engineers, covering schema and index design, query optimization, replication, scaling, and server tuning. Readers learn to diagnose bottlenecks and configure MySQL for high-throughput production workloads.
SQL Performance Explained
A concise, vendor-neutral book on SQL indexing for developers, covering B-tree internals, WHERE-clause indexing, joins, sorting, and partial results across Oracle, MySQL, PostgreSQL, and SQL Server. Readers learn to design indexes that make queries fast.
SQLShack
Free article library started by ApexSQL, written by SQL Server professionals, covering T-SQL, indexing, query tuning, backup and recovery, high availability, auditing and SSIS. Readers can follow step-by-step examples to administer, secure and tune SQL Server instances.