SQL Performance Explained Everything Developers Need to Know about SQL Performance by Markus Winand
**Intact Gift Giving Condition book**
The focus is on SQL—it covers all major SQL databases without getting lost in the details of any one specific product. SQL Performance Explained helps developers to improve database performance. 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