Aikesheng Open Source Community
Sep 21, 2020 · Databases
Understanding Semi‑join Materialization in MySQL Subquery Optimization
This article explains how MySQL transforms eligible subqueries into semi‑joins, describes the four semi‑join strategies, and details the Semi‑join Materialization approach—including Materialization‑scan and Materialization‑lookup—while showing how to identify the chosen strategy via EXPLAIN output.
Database PerformanceMaterializationMySQL
0 likes · 9 min read