{"product_id":"sql-performance-explained-everything-developers-need-to-know-about-sql-performance","title":"SQL Performance Explained Everything Developers Need to Know about SQL Performance","description":"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.\nStarting 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.\nTopics covered include:\n• Using multi-column indexes\n• Correctly applying SQL functions\n• Efficient use of LIKE queries\n• Optimizing join operations\n• Clustering data to improve performance\n• Pipelined execution of ORDER BY and GROUP BY\n• Getting the best performance for pagination queries\n• Understanding the scalability of databases\n\nIts systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer’s bookshelf.\nCovers all major databases: Oracle® Database, SQL Server®, PostgreSQL, MySQL\nWhat readers say:\n“This book is definitively worth having in the company library.” — Joe Celko\u003cbr\u003eASIN: 3950307826\u003cbr\u003eVSKU: DBV.3950307826.G\u003cbr\u003eCondition: Good\u003cbr\u003eAuthor\/Artist:Markus Winand\u003cbr\u003eBinding: Paperback\u003cbr\u003e\u003cb\u003eNote:\u003c\/b\u003e Any images shown are stock photographs and product may differ from what is shown.  \u003cbr\u003e\u003cb\u003eCondition Notes\u003c\/b\u003e: Gently used with minimal wear on the corners and cover. A few pages may contain light highlighting or writing, but the text remains fully legible. Dust jacket may be missing, and supplemental materials like CDs or codes may not be included. May be ex-library with library markings. Ships promptly!  \u003cbr\u003e","brand":"Dream Books Co.","offers":[{"title":"Default Title","offer_id":41859234398266,"sku":"DBV.3950307826.G","price":33.69,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0555\/6011\/0138\/files\/3950307826-0.jpg?v=1793161556","url":"https:\/\/shop.dreambooksco.com\/products\/sql-performance-explained-everything-developers-need-to-know-about-sql-performance","provider":"Dream Books Co.","version":"1.0","type":"link"}