Goodreads helps you keep track of books you want to read.
Start by marking “SQL Performance Explained” as Want to Read:
SQL Performance Explained
Enlarge cover
Rate this book
Clear rating
Open Preview

SQL Performance Explained

4.32  ·  Rating details ·  174 ratings  ·  27 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-rel ...more
Paperback, 204 pages
Published July 30th 2012 by Markus Winand (2012) (first published March 8th 2011)
More Details... Edit Details

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about SQL Performance Explained, please sign up.
Popular Answered Questions
Ralph N There is the free edition as an e-book online. Just search for Use the Index Luke on Google.

Community Reviews

Showing 1-30
Average rating 4.32  · 
Rating details
 ·  174 ratings  ·  27 reviews


More filters
 | 
Sort order
Start your review of SQL Performance Explained
Pavel
May 21, 2014 rated it really liked it
Shelves: technical
A tiny book containing a lot of useful material. Very relevant for developers who are also responsible for the database.
Michael Gaudet
Jan 27, 2018 rated it it was amazing
This is by far the most valuable SQL book I’ve ever read. I got hooked on Markus’ free version of this text on his website, and ended up buying a hard copy to show my support and to have it readily available.

The premise of this book is that developers should have a working knowledge of how SQL indexing can be most effectively used to retrieve data. Since developers have an intimate knowledge of what data is required by the application, they are in a better position to design efficient queries th
...more
Knut
Jul 14, 2016 rated it it was amazing
Good introduction into how databases uses indices to make effective and efficient queries. Relatively small chapters that focus on one topic at a time and use examples and visualization a to explain the topics discussed. I had never read anything about SQL performance before and this served as a very good introduction. I imagine this being a good reference to come back to when tackling performance problems.
Jon Gauthier
Mar 31, 2012 rated it really liked it  ·  review of another edition
Recommends it for: Developers who build / maintain / optimize SQL schemas / queries
Shelves: programming
This little book contains so many useful nuggets of information. It focuses largely on indexes, but also touches on things like query parameters and their gotchas. With each major feature Winand includes a table listing usage details specific to each SQL implementation. Definitely worth a read.
Ulas Tuerkmen
Oct 08, 2018 rated it it was amazing
It's really strange that there are so few SQL and relational data management books written for a general developer audience. RDBMS systems are integrated in all kinds of applications that deal with user data, and a big majority of web aplications interface to them. The job of creating, running and optimizing SQL, however, has been delegated to specialized subsystems such ORM's, and DB administrators. The results are the various horrendously performing web applications that I have had the pleasur ...more
Sergey Machulskis
Apr 15, 2020 rated it it was amazing
Shelves: professional
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 https://use-the-index-luke.com/sql/ta...

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 in
...more
Danny
Jul 11, 2018 rated it really liked it
Shelves: read-in-2018
Great little book, just going through the first chapter on how the specific index algorithms work (behind the scenes) is worth the small price tag.
Bugzmanov
Dec 22, 2019 rated it it was amazing
Shelves: 2019
Short and solid. Delivers what is promised in a concise, no-bs way. I wish there were more books like this.
Michael
Sep 19, 2017 rated it really liked it
Shelves: computers, nonfiction
Important stuff to know for designing and maintaining a database.
Lucija
Apr 29, 2018 rated it it was amazing
Very useful and easy to read, Contains lots of examples.
Brus
Aug 11, 2018 rated it it was amazing
Every backend developer should read this book
Max Borysov
Jul 24, 2019 rated it it was amazing
Shelves: 2019-done
Amazing book. It was a real pleasure to read it.
Tito Brahmanto
Feb 28, 2017 rated it it was amazing
This is the best SQL Performance book I've read so far.
chalda
Jan 27, 2017 rated it really liked it
I read a review at https://www.root.cz/clanky/markus-win... and I was thinking quite a long time to read it.
Maybe probably I had quite a big expectations I was not so excited as I thought. I really like the first chapter where is explained how relational databases work with index and what consequences it has. Other interesting chapter was about EXPLAIN command and its usage. That's what I didn't know much in details.
Next chapters are then about particular parts of SQL commands and how they influ
...more
Jean-Luc
Doesn't apply to my job at all, but it's nice to know how database systems are implemented. Certainly more useful than any of the textbooks I've seen on the topic. Covers Microsoft SQL Server, MySQL, Postgres, and Oracle (author's database software of choice).

Doesn't cover nosql databases at all, and that's fine. How those work, or whether they do, is something I'm happy to put off investigating.

If you're an IT professional and you use SQL databases, then you owe it to yourself to pick up a cop
...more
Marek Suscak
Jun 12, 2016 rated it it was amazing
Shelves: computer-science
This is a must-read for every software engineer who maintains a software system that uses an SQL database as the data store. The book goes into the nitty-gritty details of the DB indexing which is a valuable information to have when working with any DB system.

Markus is well-known in the community of DB specialists, not only for this book but also for the complementary website use-the-index-luke.com and for insightful workshops he ran and talks he gave all around the globe.
Mahmoud Tantawy
May 20, 2014 rated it it was amazing
i read the book online @ use-the-index-luke.com
The book is great, however it is not a book to read once and forget about because one should always get back to it & try to implement what is learned from it and enhance the queries bit by bit.

Everything was clear, and i liked that the author doesn't speak generally all the time but mentions specific DBs as SQL Server/MySQL/Oracle/PostgreSQL.
...more
CJ
Jul 08, 2016 rated it it was amazing
Easily the best book on SQL performance I've seen. Is cross-platform, covering Oracle, DB2, MSSQL and MySQL. Highly recommended if you want to learn how SQL queries are interpreted by the database engine.
Andrzej Hołowko
Nov 17, 2015 rated it it was amazing  ·  review of another edition
Shelves: owned, favorites
Short, well organized book, with a lot of good examples and explanations. It should be one of the first books after SQL course. I regret I haven't read it earlier.
One minus: There is no mobi or ebub version, nevertheless kindle handle pdf version well
Andy Wang
Apr 10, 2015 rated it it was amazing  ·  review of another edition
Really love this book, I indeed learned how indexes work in one week. I've written a book review at http://climber2002.github.io/blog/201... ...more
Ignacio
Nov 19, 2016 rated it really liked it
Shelves: development
Excellent book. I prepared some slides about it: http://juanignaciosl.github.io/postgr... ...more
Jan Holcapek
May 28, 2015 rated it it was amazing
Shelves: own, paperback
The best book on SQL performance by far: short, comprehensible, to the point.
Alex
Aug 30, 2016 rated it it was amazing
Informative short book.
Jose Manuel
Oct 17, 2016 rated it really liked it
Muy interesante si te dedicas a la optimización de consultas. Cubre los principales motores de bbdd
Peter Dulačka
rated it really liked it
Dec 15, 2013
Dung Hoang
rated it really liked it
Jun 14, 2020
Bob Lail
rated it liked it
Jul 14, 2018
Eric
rated it it was amazing
Jul 03, 2016
Qingyuan Zhang
rated it it was amazing
Jan 04, 2017
« previous 1 3 4 5 6 next »
There are no discussion topics on this book yet. Be the first to start one »

Readers also enjoyed

  • Designing Data-Intensive Applications
  • Clean Code: A Handbook of Agile Software Craftsmanship
  • The Pragmatic Programmer: From Journeyman to Master
  • The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
  • Dependency Injection Principles, Practices, and Patterns
  • JavaScript: The Definitive Guide
  • Eloquent JavaScript: A Modern Introduction to Programming
  • Building Microservices: Designing Fine-Grained Systems
  • Deep Learning with Python
  • Dependency Injection: Design Patterns using Spring and Guice
  • HTML and CSS: Design and Build Websites
  • Clean Architecture
  • Design Patterns: Elements of Reusable Object-Oriented Software
  • Hands-On Machine Learning with Scikit-Learn and TensorFlow
  • Apprenticeship Patterns: Guidance for the Aspiring Software Craftsman
  • Cryptography Engineering: Design Principles and Practical Applications
  • Go in Practice
See similar books…

Goodreads is hiring!

If you like books and love to build cool products, we may be looking for you.
Learn more »

News & Interviews

Myths and mayhem, the fantastical and the scientifically plausible, these are readers’ most popular sci-fi and fantasy novels published in the ...
69 likes · 12 comments