Lesson 21 of the SQL Optimization Course: Composite Indexes 2
This article explores MySQL composite index unsuitable scenarios and optimization strategies through detailed SQL execution plan analyses.
ytt
Read More
9 min
Latest Articles
Unlocking Efficient Queries: A Practical Guide to SQL Optimization & Database Performance
Predicate Pushdown Performance Optimization Scheme
Unlock 100x faster MySQL queries by mastering LIKE optimization through range scans and index-aware SQL rewriting. Discover how SQLFlash leverages B+ tree principles to eliminate full-table scans and boost database performance.
Rebooter.S
Read More
5 min
Window Function Performance Comparison and Optimization Strategies
This report compares MySQL TopN query optimizations using window functions, showcasing a two-order performance boost via CTE and LIMIT strategies with SQLFlash. Original 8-second queries optimized to 10ms through execution plan analysis and indexing strategies.
Rebooter.S
Read More
5 min
Lesson 19 of the SQL Optimization Course: Mastering MySQL Functional Indexes
Discover how MySQL functional indexes optimize query performance and simplify complex data retrieval.
ytt
Read More
6 min
Lesson 18 of the SQL Optimization Course: Understanding Prefix Indexes
Explore how MySQL prefix indexes optimize query performance and storage efficiency.
ytt
Read More
5 min
Lesson 16 of the SQL Optimization Course: Primary Key Design
Explore MySQL primary key design best practices, including space efficiency, ordering, data types, and alternatives to UUIDs for optimal performance.
ytt
Read More
7 min
SQL Optimization Case Study: Using '=' Instead of 'IN' for Instant Performance Gains!
Optimize SQL queries by replacing IN with = for unique subquery results, achieving dramatic performance improvements in execution time and resource usage.
Rebooter.S
Read More
3 min
Lesson 14 of the SQL Optimization Course: Index Design (B+ Tree Organization)
B+ Trees optimize database indexing by reducing disk I/O and improving query efficiency. Learn how they power MySQL indexing.
ytt
Read More
8 min
Lesson 13 of the SQL Optimization Course: Data Page Merging
Adjusting MERGE_THRESHOLD optimizes data page merging and splitting in MySQL InnoDB, enhancing performance.
ytt
Read More
7 min
Lesson 12 of the SQL Optimization Course: How MySQL Calculates Table Statistics?
Explore MySQL's table statistics calculation, including persistent vs non-persistent options and optimization strategies.
ytt
Read More
4 min