Aikesheng Open Source Community
Dec 30, 2019 · Databases
Understanding MySQL Full‑Table‑Scan Data Access and Field Filtering Process
This article explains how MySQL processes a full‑table‑scan query, detailing the construction of read‑sets, template creation, cursor positioning, row conversion to MySQL format, where‑clause filtering, and subsequent row iteration, while highlighting the performance impact of the number of selected fields.
Database InternalsFull Table ScanRead Set
0 likes · 11 min read