{"product_id":"sql-performance-explained-everything-developers-need-to-know-about-sql-performance-3950307826-used","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 Used\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":52342850781472,"sku":"USED3950307826","price":56.66,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0980\/7426\/3840\/files\/81mZJiObMSL_cd5e2013-d3dc-44b6-a661-d0a8c1e99f3a.jpg?v=1789183121","url":"https:\/\/miakarts.com\/products\/sql-performance-explained-everything-developers-need-to-know-about-sql-performance-3950307826-used","provider":"Miakarts Books","version":"1.0","type":"link"}