
SQL Performance Explained
Markus Winand · 2011
Programming and computer science › Databases and distributed data
#1,521 most recommended
Hacker News
34
mentions by 28 people · top 10% of 15,732 books
Open Library
5.00★★★★★★★★★★
1 rating · 3 want to read
Wikipedia
—
No article yet
About the book
How relational databases use indexes, with a focus on B-tree indexes, and how query execution depends on them. It covers Oracle, SQL Server, PostgreSQL and MySQL, aimed at application developers who write SQL. Most SQL performance problems come from indexes that do not match the query, or from SQL that prevents the database from using an index that exists. The author's central claim is that a developer who understands how a B-tree is searched and scanned can fix these problems without deep database internals or hardware changes. The book works through common patterns, such as column order in composite indexes, conditions that hide an indexed column, and sorting and joins, to show when an index helps and when it does not.
Written by Claude from what it knows of this book.
What Hacker News says 93% recommend · 0% critical
In the commenters’ own words
In the project I'm currently working on, objects are fetched from the database using ORM queries and then the results are iterated over, filtered further and…
I own many more books than I will ever read. I also own many books where I have read maybe 2 chapters, usually the first two but not always. Of course, I…
What Open Library readers say 5.00 from 1 rating
- 51
- 40
- 30
- 20
- 10
- 3 want to read
- 0 reading
- 1 have read
Only 1 rating: treat the average as a hint.
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
The threads it came up in
- Ask HN: Best books read in 2022?
- Ask HN: What language-agnostic programming books should I read?
- Ask HN: Books you should have read when you start a career in SE / CS?
- Ask HN: What's the best book you've read regarding software development?
- Ask HN: Tech books or articles that teach long-lasting concepts?
Details
- First published
- 2011
- Editions known
- 2 at Open Library
- Open Library
- OL15667878W
Read next: its neighbours on the mosaic
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · 2 people recommended both
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · 5 people recommended both
Learning SQLAlan Beaulieu · 2005 · recommended by 3 people · similar by subject and what people say about it
Elements of programmingAlexander A. Stepanov · 2009 · recommended by 31 people · 2 people recommended both
Systems PerformanceBrendan Gregg · 2013 · recommended by 32 people · 2 people recommended both
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 people · similar by subject and what people say about it
The effective engineerEdmond Lau · 2015 · recommended by 19 people · similar by subject and what people say about it
The Pragmatic ProgrammerAndy Hunt · 1999 · recommended by 353 people · 4 people recommended both
PostgreSQL 9.0 High PerformanceGregory Smith · 2010 · recommended by 12 people · similar by subject and what people say about it
The Every Computer Performance BookBob Wescott · 2013 · recommended by 2 people · similar by subject and what people say about it
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 people · similar by subject and what people say about it
Clean CodeRobert C. Martin · 2008 · recommended by 298 people · 2 people recommended both
Patterns of Enterprise Application ArchitectureMartin Fowler · 2002 · recommended by 34 people · named together in 2 comments
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 people · similar by subject and what people say about it
High Performance Browser NetworkingIlya Grigorik · 2013 · recommended by 58 people · similar by subject and what people say about it
High Performance JavaScriptNicholas C. Zakas · 2010 · recommended by 14 people · similar by subject and what people say about it
Clean ArchitectureRobert C. Martin · 2017 · recommended by 47 people · named together in 2 comments
The Manga Guide to DatabasesMana Takahashi · 2005 · recommended by 11 people · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it