{"product_id":"markus-winand-sql-performance-explained-everything-developers-need-to-know-about-sql-performance-9783950307825","title":"SQL Performance Explained","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":"Markus Winand","offers":[{"title":"Gebraucht - Wie neu","offer_id":53754815218006,"sku":"9783950307825-N","price":45.79,"currency_code":"EUR","in_stock":true},{"title":"Gebraucht - Sehr gut","offer_id":53561876119894,"sku":"9783950307825-V","price":44.99,"currency_code":"EUR","in_stock":true},{"title":"Gebraucht - Gut","offer_id":54801038082390,"sku":"9783950307825-G","price":47.79,"currency_code":"EUR","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0925\/5829\/5382\/files\/product_image_9783950307825_1_78a9100e-de91-4e97-891b-fcc6b3f7564b.jpg?v=1789869659","url":"https:\/\/www.momoxbooks.com\/de\/products\/markus-winand-sql-performance-explained-everything-developers-need-to-know-about-sql-performance-9783950307825","provider":"momox","version":"1.0","type":"link"}