SQL Performance Explained
A short book on SQL indexing and query performance for developers, with examples for MySQL, PostgreSQL, Oracle, and SQL Server — and a free web edition, Use The Index, Luke.
SQL Performance Explained explains how database indexes work and how to write queries that use them — the WHERE clause, joins, sorting and grouping, partial results, and inserts, updates, and deletes — in under 200 pages. Rather than covering one database, it shows the same concepts and execution plans across MySQL, PostgreSQL, Oracle, and SQL Server.
The full content is free online as Use The Index, Luke, which the author keeps current; its MySQL examples have been tested on versions from 5.5 to 9.7. The book is sold directly by the author as a paperback or PDF.
Community feedback
This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.