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.

SQL Performance Explained帮助开发人员提高数据库性能。本书的重点是SQL--它涵盖了所有主要的SQL数据库，而不会迷失在任何一个特定产品的细节中。从索引和WHERE子句的基础知识开始，《SQL性能详解》引导开发人员了解SQL语句的所有部分，并解释了Hibernate等对象关系映射（ORM）工具的陷阱。涵盖的主题包括。使用多列索引；正确应用SQL函数；有效使用LIKE查询；优化连接操作；对数据进行分组以提高性能；流水线式执行ORDER BY和GROUP BY；为分页查询获得最佳性能；了解数据库的可扩展性。它的系统结构使《SQL性能解释》既是一本教科书，又是一本参考手册，应该放在每个开发人员的书架上。