--- product_id: 66162535 title: "SQL Performance Explained" price: "83040CFA" currency: XOF in_stock: true reviews_count: 13 url: https://burkinafaso.desertcart.com/products/66162535-sql-performance-explained store_origin: BF region: Burkina Faso --- # SQL Performance Explained **Price:** 83040CFA **Availability:** ✅ In Stock ## Quick Answers - **What is this?** SQL Performance Explained - **How much does it cost?** 83040CFA with free shipping - **Is it available?** Yes, in stock and ready to ship - **Where can I buy it?** [burkinafaso.desertcart.com](https://burkinafaso.desertcart.com/products/66162535-sql-performance-explained) ## Best For - Customers looking for quality international products ## Why This Product - Free international shipping included - Worldwide delivery with tracking - 15-day hassle-free returns ## 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. Starting 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. Topics covered include: • Using multi-column indexes • Correctly applying SQL functions • Efficient use of LIKE queries • Optimizing join operations • Clustering data to improve performance • Pipelined execution of ORDER BY and GROUP BY • Getting the best performance for pagination queries • Understanding the scalability of databases Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer’s bookshelf. Covers all major databases: Oracle® Database, SQL Server®, PostgreSQL, MySQL What readers say: “This book is definitively worth having in the company library.” — Joe Celko Review: An eye-opener on SQL performance - before: 'Hmm, I need to do the thing with the data'; hack together SQL in Squirrel until it gives the correct answer; copy SQL into program; think 'it worked in dev and test' when it turns out to be horribly slow in production; sprinkle indexes; see moderate improvements; leave alone. now: 'Hmm, I need to do the thing with the data'; write SQL to get data, bearing in mind table indexes, join criteria, and the ease with which the database optimiser will be able to narrow down to the target data; run explain plans and check costs; remember that I need real data volumes for the explain plans to be representative of production, and repeat; copy SQL into program; never hear about it again. And all in less than two hundred pages which--while they could be quickly summarised as 'use indexes effectively'--don't waste any time with history lessons, edge-cases, or other forms of padding. Throughout this, it still manages to highlight the differences between Oracle, SQL Server, MySQL and PostgreSQL. I can't really offer any criticism here, hence the five stars, but if there is ever going to be a follow up then I'd like to see some coverage of DB2. Review: Delivers Results - I have a database with 7.5 million records and I was struggling with a query that was taking about 1 minute, 30 seconds to execute. 43 pages in and it is now executing in 3 seconds. This is exactly the result I was looking for. This is a technical book, aimed specifically at application developers, however it is well written and is not too heavy on the guts of databases. The first part of the book explains indexing very clearly and very simply. It then goes on to highlight the finer points of joins, sorting, clustering etc. Worked for me. ## Technical Specifications | Specification | Value | |---------------|-------| | Best Sellers Rank | 620,649 in Books ( See Top 100 in Books ) 66 in SQL Databases | | Customer Reviews | 4.6 out of 5 stars 108 Reviews | ## Images ![SQL Performance Explained - Image 1](https://m.media-amazon.com/images/I/81mZJiObMSL.jpg) ## Customer Reviews ### ⭐⭐⭐⭐⭐ An eye-opener on SQL performance *by D***S on 16 March 2016* before: 'Hmm, I need to do the thing with the data'; hack together SQL in Squirrel until it gives the correct answer; copy SQL into program; think 'it worked in dev and test' when it turns out to be horribly slow in production; sprinkle indexes; see moderate improvements; leave alone. now: 'Hmm, I need to do the thing with the data'; write SQL to get data, bearing in mind table indexes, join criteria, and the ease with which the database optimiser will be able to narrow down to the target data; run explain plans and check costs; remember that I need real data volumes for the explain plans to be representative of production, and repeat; copy SQL into program; never hear about it again. And all in less than two hundred pages which--while they could be quickly summarised as 'use indexes effectively'--don't waste any time with history lessons, edge-cases, or other forms of padding. Throughout this, it still manages to highlight the differences between Oracle, SQL Server, MySQL and PostgreSQL. I can't really offer any criticism here, hence the five stars, but if there is ever going to be a follow up then I'd like to see some coverage of DB2. ### ⭐⭐⭐⭐⭐ Delivers Results *by M***. on 1 July 2013* I have a database with 7.5 million records and I was struggling with a query that was taking about 1 minute, 30 seconds to execute. 43 pages in and it is now executing in 3 seconds. This is exactly the result I was looking for. This is a technical book, aimed specifically at application developers, however it is well written and is not too heavy on the guts of databases. The first part of the book explains indexing very clearly and very simply. It then goes on to highlight the finer points of joins, sorting, clustering etc. Worked for me. ### ⭐⭐⭐⭐ Very good book *by D***. on 29 August 2014* I purchased this book principally for learning SQL tunning/Performance for oracle database however the book covers several widely used DBMS such as oracle, PostgreSQL, mysql, sql server, MySQL, . . . The domain is quite vast & as a beginner, if you just check the online oracle documentation, you can hardly find your way. This book opens the door. You learn the basic concepts and terminology (what is a BTree index, how it is read and how it can impact performance). There are many interesting examples, each of them, provided with execution plans. At the end of the book there is a summary of how to read an execution plan (dedicated section for each DBMS) The author uses a simple language and in general it seems that the book addresses principally those who almost don't know much about the performance problems. Yet I believe non beginners can also benefit from the interesting scenarios described in the book for investigating and tackling performance problems (very good & classic examples) The accent has been put on indexes. You will learn different type of indexes, how to improve them, how a database read an index, doing different type of index/table scans, how to investigate the cause of a slow query, etc. Personally I liked the book and I recommend it. I would've preferred to see more details in the book about the meaning of each section of an execution plan. Also it would be more helpful if the author gives more details about hash joins and hash group by. My conclusion: Excellent book and I recommend it. ## Frequently Bought Together - SQL Performance Explained Everything Developers Need to Know about SQL Performance - SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers) - The Art of SQL --- ## Why Shop on Desertcart? - 🛒 **Trusted by 1.3+ Million Shoppers** — Serving international shoppers since 2016 - 🌍 **Shop Globally** — Access 737+ million products across 21 categories - 💰 **No Hidden Fees** — All customs, duties, and taxes included in the price - 🔄 **15-Day Free Returns** — Hassle-free returns (30 days for PRO members) - 🔒 **Secure Payments** — Trusted payment options with buyer protection - ⭐ **TrustPilot Rated 4.5/5** — Based on 8,000+ happy customer reviews **Shop now:** [https://burkinafaso.desertcart.com/products/66162535-sql-performance-explained](https://burkinafaso.desertcart.com/products/66162535-sql-performance-explained) --- *Product available on Desertcart Burkina Faso* *Store origin: BF* *Last updated: 2026-08-09*