MySQL OR Condition to UNION ALL
This article demonstrates how optimizing MySQL OR conditions with UNION ALL significantly improves query performance, based on experimental results and execution plan analysis.
Rebooter.S
Read More
6 min
Tag: MySQL Optimization
7 posts
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive
Explore MySQL 8.0's optimizer enhancements including GROUP BY sorting changes, derived condition pushdown, and subquery-to-derived table conversion. Learn how these improvements reduce filesort operations and enhance query execution efficiency through practical benchmarking.
Rebooter.S
Read More
18 min
Lesson 24 of the SQL Optimization Course: Index Condition Pushdown
Learn how MySQL index cardinality impacts query performance, including factors affecting accuracy, practical optimization techniques, and real-world case studies demonstrating the balance between read/write efficiency.
ytt
Read More
3 min
Lesson 23 of the SQL Optimization Course: Index Cardinality and Selectivity
Learn how MySQL index cardinality impacts query performance, including factors affecting accuracy, practical optimization techniques, and real-world case studies demonstrating the balance between read/write efficiency.
ytt
Read More
3 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 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
Lesson 9 of the SQL Optimization Course: How to Choose the Right MySQL Tablespace
Explore MySQL's tablespace types with pros and cons. This guide helps you pick the best one to boost performance and ease management.
ytt
Read More
3 min