Articoli correlati a SQL Performance Explained

SQL Performance Explained - Brossura

Unknown

 
9783950307825: SQL Performance Explained
Brossura
ISBN 10: 3950307826 ISBN 13: 9783950307825
Casa editrice: Markus Winand, 1780

Sinossi

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

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Editore
Markus Winand
Data di pubblicazione
1780
Lingua
Inglese
ISBN 10 
3950307826
ISBN 13 
9783950307825
Rilegatura
Copertina flessibile
Contatto del produttore
non disponibile
Persona responsabile
non disponibile