SQL Performance Explained Everything Developers Need to Know about SQL Performance

SQL Performance Explained Everything Developers Need to Know about SQL Performance

<p><em>SQL Performance Explained</em> 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.</p> <p>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.</p> <p> Topics covered include:<br/>  • Using multi-column indexes<br/>  • Correctly applying SQL functions<br/>  • Efficient use of LIKE queries<br/>  • Optimizing join operations<br/>  • Clustering data to improve performance<br/>  • Pipelined execution of ORDER BY and GROUP BY<br/>  • Getting the best performance for pagination queries<br/>  • Understanding the scalability of databases<br/> </p> <p>Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer's bookshelf.</p> <p>Covers all major databases: Oracle® Database, SQL Server®, PostgreSQL, MySQL</p> <p><b>What readers say:</b><br/> <em>"This book is definitively worth having in the company library."</em> - Joe Celko </p>