1 neufs partir de EUR 29,95
Vous l'avez déjà ?
Repliez vers l'arrière Repliez vers l'avant
Ecoutez Lecture en cours... Interrompu   Vous écoutez un extrait de l'édition audio Audible
En savoir plus
Voir cette image

SQL Performance Explained (Anglais) Broché – 2012

5.0 étoiles sur 5 2 commentaires client

Voir les 2 formats et éditions Masquer les autres formats et éditions
Prix Amazon
Neuf à partir de Occasion à partir de
"Veuillez réessayer"
EUR 29,95

Cahiers de vacances Cahiers de vacances

click to open popover

Offres spéciales et liens associés

Quels sont les autres articles que les clients achètent après avoir regardé cet article?

Description du produit

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

What readers say:
"This book is definitively worth having in the company library." - Joe Celko

Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.

  • Apple
  • Android
  • Windows Phone
  • Android

Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.

Détails sur le produit

Commentaires en ligne

5.0 étoiles sur 5
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoile
Voir les deux commentaires client
Partagez votre opinion avec les autres clients

Meilleurs commentaires des clients

Format: Broché Achat vérifié
l'exemple parfait du livre qui vous fait avancer dans votre vie professionnelle.
rien d'autre à ajouter si ce n'est que je le conseille
Remarque sur ce commentaire 2 personnes ont trouvé cela utile. Avez-vous trouvé ce commentaire utile ? Oui Non Commentaire en cours d'envoi...
Merci pour votre commentaire.
Désolé, nous n'avons pas réussi à enregistrer votre vote. Veuillez réessayer
Signaler un abus
Par Fred le 11 août 2014
Format: Broché Achat vérifié
très bon livre, un excellent investissement pour comprendre puis optimiser la vitesse de certains traitements. Une bonne connaissance des bases de données est évidement requise.
Remarque sur ce commentaire Avez-vous trouvé ce commentaire utile ? Oui Non Commentaire en cours d'envoi...
Merci pour votre commentaire.
Désolé, nous n'avons pas réussi à enregistrer votre vote. Veuillez réessayer
Signaler un abus

Commentaires client les plus utiles sur Amazon.com (beta) (Peut contenir des commentaires issus du programme Early Reviewer Rewards)

Amazon.com: 4.9 étoiles sur 5 17 commentaires
3 internautes sur 3 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 This book is good, really good 9 janvier 2016
Par Sorpigal - Publié sur Amazon.com
Format: Broché Achat vérifié
This book is good, really good.

Optimizing SQL, writing performant queries, is something that every developer dealing with databases ought to know how to do but it is not something taught in any SQL class I've seen or, if it is, it's always either taught steeped in an RDBMS-specific way that makes the knowledge difficult to apply to other databases or so academically that it's hard to know how any of it applies. This book covers SQL in general but, importantly, makes it concrete by providing examples in *multiple* popular databases. It also takes the time to explain peculiarities of different implementations, by which I mostly mean Oracle, which is something all general SQL tutorials seem to avoid.

Although nothing in here was a revelation to me for a lot of people it will be, and even I found nuggets of usefulness despite having a decade of experience in database performance tuning. This book lays out in simple, clear terms the things you need to know and is written in sufficiently non-arcane language that even an entry level developer should be able to follow it. I am certainly going to use this book as my way of explaining query optimization to all future developers I must teach, because it expresses these ideas far more lucidly than I have been able to manage.

5/5, would gather statistics again
1 internautes sur 1 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Book of the Year 17 juillet 2015
Par Jack Leach - Publié sur Amazon.com
Format: Broché Achat vérifié
I got it in the mail two days ago and cracked it open last night, and probably learned more in the first 50 pages than I’ve ever learned in that short amount of time reading a book. I’ll probably have to go through it a few times before I feel I have a complete understanding of everything, but for all I’ve tried to learn about how indexing “really” works from various SQL books (of which I have many…), this is the only one that is explained in a manner that’s easy enough to follow where you can get some practical knowledge from it.

Highly recommended if you don’t have a copy. This book *must* be able to help any database developer except those that already have vast amounts of knowledge of how indexes are implemented and what the implications on performance are. It’s like taking all the grey areas that have “just worked” for the past ten years and lifting the fog off it to see what’s actually lurking behind there, and it also opens the gateways to a whole new study focus that have been very difficult to obtain previously due to lack of solid concept to work from.

Definitely Book of the Year for me, I think (I’d be more than happy to have it topped before the year’s up).
1 internautes sur 1 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Performance Basics for SQL engines explained. 29 décembre 2016
Par Arthur - Publié sur Amazon.com
Format: Broché Achat vérifié
Good read. This book explains query plans and how to read them. The information applies to just about any database platform, including Oracle, Microsoft T-SQL, My SQL, ... For those who work with, and write queries against databases where performance is a concern, this book is a must.
5.0 étoiles sur 5 Absolutely Worth a Read 12 septembre 2015
Par Arthur Maciejewicz - Publié sur Amazon.com
Format: Broché Achat vérifié
If you've read "Use the Index Luke!", you have to read this book. I purchased it and made it available to everyone in my office. The first two chapters alone are worth the read; I took a University level Relational Databases course that wasn't as useful as this book. The writing is clear, and the author wastes no time with his explanations. I'm currently working with MySQL, and unfortunately due to limitations with its design, some sections don't apply. Still, understanding how indexes work, the different join algorithms, how to read EXPLAIN output, and how to structure queries it absolutely worth this low price. I also recommend reading your database's documentation once you've finished this book, because it will be much more understandable
5.0 étoiles sur 5 but still gives a good understanding of database fundamentals and will help you understand ... 7 août 2016
Par Mike Kasberg - Publié sur Amazon.com
Format: Broché Achat vérifié
I already knew SQL, but needed to brush up on query optimization. This book is well-written and concise. I appreciate the fact that it's not 1,000 pages long, but still gives a good understanding of database fundamentals and will help you understand how queries work. You need to know what queries are actually doing in memory and on disk if you're going to optimize them. A word of caution though - this is not a book for SQL beginners. You'll be lost in the first paragraph if you're not already familiar with the basics of SQL.
Ces commentaires ont-ils été utiles ? Dites-le-nous