Tag: Execution Plan Analysis

2 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

Aug 18, 2025

Non-Correlated Subquery Optimization with Index-Driven Execution

Boost MySQL query performance by 217x using index-driven execution strategies for non-correlated subqueries. Eliminate full table scans, reduce I/O overhead, and optimize execution paths for large datasets. Practical OLTP solutions with metrics and case studies.

Rebooter.S

Jul 9, 2025