Customer Reviews


6 Reviews
5 star:
 (5)
4 star:
 (1)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
Share your thoughts with other customers
Create your own review
 
 
Most Helpful First | Newest First

5.0 out of 5 stars Perfectly Practical & Commendably Concise, 5 July 2013
This review is from: SQL Performance Explained (Paperback)
It's rare to find a book that covers a breadth of detail in such a concise and clear way and the practical real-world relevance of everything covered is quite unique. The fact that the book not only covers but also explains the subtleties of different database engines (MySQL and Oracle were important here) is brilliant. It's not only really helped in understanding and optimising legacy implementations here but has made it possible to take better informed decisions going forward as well. Money very well spent in the grand scheme of things.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Delivers Results, 1 July 2013
Verified Purchase(What is this?)
This review is from: SQL Performance Explained (Paperback)
I have a database with 7.5 million records and I was struggling with a query that was taking about 1 minute, 30 seconds to execute. 43 pages in and it is now executing in 3 seconds.

This is exactly the result I was looking for.

This is a technical book, aimed specifically at application developers, however it is well written and is not too heavy on the guts of databases.

The first part of the book explains indexing very clearly and very simply. It then goes on to highlight the finer points of joins, sorting, clustering etc.

Worked for me.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Great book for developers, 14 Jun 2013
This review is from: SQL Performance Explained (Paperback)
This is a good book with just the right amount of detail for the typical SQL Developer tasked with implementing business logic and lacking the time or inclination to wade through DBA-focused tomes. Weighing in at around 200 pages, this book provides numerous insights related to index usage that are unlikely to be found in too many books this size.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Little gem for major RDBMS, 16 Oct 2012
By 
This review is from: SQL Performance Explained (Paperback)
This book is an excellent study material on the best techniques to enhance the performance of the SQL query.
It takes into account different databases: Oracle, SQL Server, MySQL and Postgresql (with a special preferences for the first one).
It is written in a flowing, very understandable language, and paginated impeccably.
Little bad only the missing number of pages' chapter in the header of your pages.
But the content is really top-notch, complete with graphs of execution plans to better understand how to operate the query.
Is an indispensable manual for anyone, DBA, developer or system administrator, cares about the performance optimization of the query.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


4.0 out of 5 stars Nice book for SQL, 16 Oct 2012
Verified Purchase(What is this?)
This review is from: SQL Performance Explained (Paperback)
It is a good read. Nicely written and well explained. It gave a good explanation about sql tuning. Must read for the developer.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


5.0 out of 5 stars Probably the best book on SQL performance I've read, 31 Aug 2012
By 
Guillaume Lelarge (France) - See all my reviews
(REAL NAME)   
Verified Purchase(What is this?)
This review is from: SQL Performance Explained (Paperback)
This book is easy to read, but still really informative. It helps simplify the whole process a database system goes through to execute SQL queries. It helps understand how to write faster queries. A really impressive job done by Markus Winand.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First
ARRAY(0xa5044ae0)

This product

SQL Performance Explained
SQL Performance Explained by Markus Winand (Paperback - 2012)
Used & New from: 26.99
Add to wishlist See buying options
Only search this product's reviews