{"product_id":"sql-performance-explained-everything-developers-need-to-know-about-sql-performance-9783950307825","title":"SQL Performance Explained Everything Developers Need to Know about SQL Performance","description":"\u003cp\u003eSQL Performance Explained helps developers to improve database performance. The focus is on SQLit 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 developers 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\u003c\/p\u003e","brand":"My Store","offers":[{"title":"Default Title","offer_id":45529667469365,"sku":"ByrdShop_3950307826","price":248.8,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0627\/8139\/0901\/files\/9783950307825.jpg?v=1780941110","url":"https:\/\/atxbooks.com\/products\/sql-performance-explained-everything-developers-need-to-know-about-sql-performance-9783950307825","provider":"ATX Books","version":"1.0","type":"link"}