Winand Markus. SQL Performance Explained

Markus Winand, Vienna, Austria, 2012. — 196 p. — ISBN: 978-3-9503078-2-5SQL 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