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
"Sinopsis" puede pertenecer a otra edición de este libro.
Gastos de envío:
EUR 3,73
A Estados Unidos de America
Descripción Paperback. Condición: new. New. Fast Shipping and good customer service. Nº de ref. del artículo: Holz_New_3950307826
Descripción Paperback. Condición: Brand New. 204 pages. 9.06x5.91x0.55 inches. In Stock. Nº de ref. del artículo: 3950307826
Descripción Paperback. Condición: new. New Copy. Customer Service Guaranteed. Nº de ref. del artículo: think3950307826
Descripción Condición: new. Book is in NEW condition. Satisfaction Guaranteed! Fast Customer Service!!. Nº de ref. del artículo: PSN3950307826
Descripción Condición: new. Nº de ref. del artículo: Hafa_fresh_3950307826
Descripción Paperback. Condición: new. New. Nº de ref. del artículo: Wizard3950307826
Descripción Condición: new. Nº de ref. del artículo: FrontCover3950307826
Descripción Paperback. Condición: new. Buy for Great customer experience. Nº de ref. del artículo: GoldenDragon3950307826