SQL Performance Explained

Paperback, 204 pages

Published May 28, 2012 by Markus Winand.

ISBN:: 978-3-9503078-2-5

(2 reviews)

SQL Performance Explained helps developers to improve database performance. The focus is on SQL—it covers all major SQL databases without getting lost in the details of any one specific product.

Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.

Topics covered include: • Using multi-column indexes • Correctly applying SQL functions • Efficient use of LIKE queries • Optimizing join operations • Clustering data to improve performance • Pipelined execution of ORDER BY and GROUP BY • Getting the best performance for pagination queries • Understanding the scalability of databases

Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer’s bookshelf.

Covers all major databases: Oracle® Database, SQL Server®, PostgreSQL, MySQL

1 edition

Sergey Machulskis reviewed SQL Performance Explained by Markus Winand

Review of 'SQL Performance Explained' on 'Goodreads'

5 stars

It's short and very well-written. It's the most valuable read on SQL I've ever seen. Usually I avoid reading books online because it's distracting but I couldn't switch to anything else until I finished it.

It's here use-the-index-luke.com/sql/table-of-contents

Hard to say what was the most useful in this book. It's dense with advice. Maybe the most important thing for backend developers is "Do NOT use OFFSET for pagination".

I wish there was a book about other index types (this one explains B-tree indexes in detail).

arcade-mood

rated it

July 14, 2021