SQL Performance Explained Everything Developers Need to Know about SQL Performance / Markus Winand


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


Now you can buy Books online in USA,UK, India and more than 100 countries.
*Terms and Conditions apply
Disclaimer: All product data on this page belongs to buy amazon.
No guarantees are made as to accuracy of prices and information.

Contact Us

Create a Bookshelf of your Favorite books
Get it on Google Play        Get it on Google Play
For Any Queries please don't hesitate to contact us at
USA +1(760)3380762
+1(650) 9808080
India +91 9023011224
India +91 9023011224 (Whatsapp)
Donate
Buy Books online because as an Amazon Associate we earn from qualifying purchases.