--- title: Database Performance description: Database performance focuses on optimizing speed, resource usage, and throughput in database systems. Learners will understand indexing, query optimization, caching strategies, and hardware tuning to resolve bottlenecks and ensure fast data retrieval. category: programming-tech subcategory: databases difficulty: beginner, intermediate, advanced url: /subject/database-performance --- # Database Performance Database performance focuses on optimizing speed, resource usage, and throughput in database systems. Learners will understand indexing, query optimization, caching strategies, and hardware tuning to resolve bottlenecks and ensure fast data retrieval. ## Available Resources 2 Books • 6 Websites ## Websites ### 1. Explain Extended **Author:** Alex Bolenok Long-running blog by Quassnoi devoted to SQL query performance, dissecting individual problems across MySQL, PostgreSQL, SQL Server and Oracle with execution plans, timings and rewritten queries. Shows why an optimizer picks a plan and how rewrites change it. **Difficulty:** Advanced | **Price:** Free **Link:** https://explainextended.com/ **Tags:** query-optimization, sql-performance, execution-plans, indexes, postgresql ### 2. PG Mustard Blog Michael Christofides' blog at pgMustard on PostgreSQL query performance: reading EXPLAIN output and query plans, indexing strategy, pg_stat_statements, and changes in new Postgres releases, with practical guidance for diagnosing and fixing slow queries. **Difficulty:** Beginner | **Price:** Free **Link:** https://www.pgmustard.com/blog **Tags:** postgresql, query-optimization, explain-analyze, indexing ### 3. Percona Blog Engineering blog from Percona, a MySQL, PostgreSQL and MongoDB support vendor. Posts benchmark storage engines, dissect replication and failover behaviour, and explain version changes, giving practitioners evidence-based guidance on tuning and operating open-source databases in production. **Difficulty:** Beginner | **Price:** Free **Link:** https://www.percona.com/blog/ **Tags:** mysql, postgresql, performance-tuning, database-administration, open-source ### 4. SQLShack Free article library started by ApexSQL, written by SQL Server professionals, covering T-SQL, indexing, query tuning, backup and recovery, high availability, auditing and SSIS. Readers can follow step-by-step examples to administer, secure and tune SQL Server instances. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://sqlshack.com **Tags:** sql-server, t-sql, database-administration, performance-tuning, backup-and-recovery ### 5. use-the-index-luke.com A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://use-the-index-luke.com **Tags:** websites, technology-computer-science, computer-sciences ### 6. percona.com Percona is an open-source database solutions site focused on performance, tuning, and optimization. It features tutorials, blogs, webinars, case studies, and tools for MySQL, PostgreSQL, and MongoDB performance, backups, and monitoring. **Difficulty:** Intermediate | **Language:** English | **Price:** Free **Link:** https://percona.com **Tags:** websites, technology-computer-science, database--backend ## Books ### 1. High Performance MySQL **Author:** Baron Schwartz, Peter Zaitsev, Vadim Tkachenko A practical guide to MySQL performance from Percona engineers, covering schema and index design, query optimization, replication, scaling, and server tuning. Readers learn to diagnose bottlenecks and configure MySQL for high-throughput production workloads. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/0596101716?tag=edmonddante07-20 **Tags:** books, technology-computer-science, database--backend ### 2. SQL Performance Explained **Author:** Markus Winand A concise, vendor-neutral book on SQL indexing for developers, covering B-tree internals, WHERE-clause indexing, joins, sorting, and partial results across Oracle, MySQL, PostgreSQL, and SQL Server. Readers learn to design indexes that make queries fast. **Difficulty:** Intermediate | **Language:** English | **Price:** Paid **Link:** https://www.amazon.com/dp/3950307826?tag=edmonddante07-20 **Tags:** books, technology-computer-science, database--backend --- *This content is part of Dantes.io - Your Treasure Map to Knowledge* *Curated by humans at Dantes.io. Personal study use welcome; republishing this curation requires permission (team@dantes.io).* View this page online: https://dantes.io/subject/database-performance