Search Site
This site uses cookies to deliver our services, improve performance, for analytics, and (if not signed in) for advertising. By using LibraryThing you acknowledge that you have read and understand our Terms of Service and Privacy Policy. Your use of the site and services is subject to these policies and terms.

Results from Google Books

Click on a thumbnail to go to Google Books.


SQL Performance Explained Everything Developers Need to Know about SQL Performance

by Markus Winand

MembersReviewsPopularityAverage ratingConversations
241909,622 (3.8)None

Sign up for LibraryThing to find out whether you'll like this book.

No current Talk conversations about this book.

To begin with I should point out that I was given the book by the author and promised to review it. The author has however had no insight into the contents of this review and have made no attempts whatsoever to influence it.

With a title like "SQL Performance Explained" it might seem strange that the book is less than 200 pages long. Don't let the page count fool you though, this book does a very good job of covering a lot of ground. The small tip boxes scattered around the pages alone have more valuable content than many other books.

The author is well known for his expertise on indexing and that obviously shines through in the book, but the topics discussed are not at all limited to indexing. The wide set of topics covered include efficient indexing and querying, join algorithms, execution plans as well as the anatomy of indexes. Care is also taken to discuss how data volumes affect query performance and database scalability. The focus of the writing is very much geared towards developers, many chapters include code samples in many common languages apart from the SQL.

The book covers specifics about the major four database engines which is as much a strength as it is a potential weakness. Anyone interested only in database X might think this book is too broad, which would be unfortunate. While most readers probably focus on their database of choice and skip over sections on the competing ones it is never a bad idea to learn more about the competition. Not to mention the great fit it is for consultants who see a wide array of environments on different assignments.

To conclude, this book is vital for any database developer, DBA as well as anyone interested in database performance. It's unlikely to be the only book in your professional library but is highly likely to be one that sticks in your memory and that you read cover to cover. It is highly likely to be your go to book. The promise the title gives is held, SQL performance is explained. ( )
  dege | Sep 8, 2013 |
no reviews | add a review
You must log in to edit Common Knowledge data.
For more help see the Common Knowledge help page.
Canonical title
Original title
Alternative titles
Original publication date
Important places
Important events
Related movies
Awards and honors
First words
Last words
Disambiguation notice
Publisher's editors
Original language
Canonical DDC/MDS
Canonical LCC

References to this work on external resources.

Wikipedia in English


No library descriptions found.

Book description
Haiku summary

Popular covers

Quick Links


Average: (3.8)
2 1
4 3
5 1

Is this you?

Become a LibraryThing Author.


About | Contact | Privacy/Terms | Help/FAQs | Blog | Store | APIs | TinyCat | Legacy Libraries | Early Reviewers | Common Knowledge | 194,531,234 books! | Top bar: Always visible