Aikesheng Open Source Community

Oct 7, 2023 · Databases

Understanding Full Table Scan vs Full Primary Key Scan in MySQL InnoDB

This article analyzes the differences between MySQL's full table scan and full primary‑key scan by examining execution plans, source‑code paths, and runtime behavior, demonstrating that both ultimately read data from the primary‑key index and explaining why the optimizer distinguishes them.