{"product_id":"sql-performance-explained-everything-developers-need-to-know-about-sql-performance-3950307826","title":"SQL Performance Explained Everything Developers Need to Know about SQL Performance","description":"\u003cp\u003e\u003cstrong\u003eISBN:\u003c\/strong\u003e 3950307826\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAuthor:\u003c\/strong\u003e Markus Winand\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCondition:\u003c\/strong\u003e New\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cem\u003eSQL Performance Explained\u003c\/em\u003e 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.\u003c\/p\u003e \u003cp\u003eStarting 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.\u003c\/p\u003e \u003cp\u003e Topics covered include:\u003cbr\u003e  • Using multi-column indexes\u003cbr\u003e  • Correctly applying SQL functions\u003cbr\u003e  • Efficient use of LIKE queries\u003cbr\u003e  • Optimizing join operations\u003cbr\u003e  • Clustering data to improve performance\u003cbr\u003e  • Pipelined execution of ORDER BY and GROUP BY\u003cbr\u003e  • Getting the best performance for pagination queries\u003cbr\u003e  • Understanding the scalability of databases\u003cbr\u003e \u003c\/p\u003e \u003cp\u003eIts systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer? bookshelf.\u003c\/p\u003e \u003cp\u003eCovers all major databases: Oracle® Database, SQL Server®, PostgreSQL, MySQL\u003c\/p\u003e \u003cp\u003e\u003cb\u003eWhat readers say:\u003c\/b\u003e\u003cbr\u003e \u003cem\u003e?his book is definitively worth having in the company library.?\/em\u0026gt; - Joe Celko \u003c\/em\u003e\u003c\/p\u003e","brand":"Mia Karts","offers":[{"title":"Default Title","offer_id":52098405761312,"sku":"NEW3950307826","price":59.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0980\/7426\/3840\/files\/81mZJiObMSL.jpg?v=1785792117","url":"https:\/\/miakarts.com\/products\/sql-performance-explained-everything-developers-need-to-know-about-sql-performance-3950307826","provider":"Miakarts Books","version":"1.0","type":"link"}