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: Database Tuning
3 posts
5 Steps to Optimize MySQL Deep Pagination
This article explores MySQL deep pagination optimization using Deferred Join technique, demonstrating 80.3% faster query performance with 99.99% fewer back-to-table operations through comprehensive testing.
Rebooter.S
Read More
5 min
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