{"product_id":"markus-winand-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\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’s 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“This book is definitively worth having in the company library.”\u003c\/em\u003e — Joe Celko \u003c\/p\u003e","brand":"Winand, Markus","offers":[{"title":"Used - like new","offer_id":53754815218006,"sku":"9783950307825-N","price":58.49,"currency_code":"EUR","in_stock":false},{"title":"Used - very good","offer_id":53561876119894,"sku":"9783950307825-V","price":56.99,"currency_code":"EUR","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0925\/5829\/5382\/files\/product_image_9783950307825_1.jpg?v=1781705695","url":"https:\/\/www.momoxbooks.com\/products\/markus-winand-sql-performance-explained-everything-developers-need-to-know-about-sql-performance-9783950307825","provider":"momoxbooks","version":"1.0","type":"link"}