Tag

MySQL Indexing

0 views collected around this technical thread.

Raymond Ops
Raymond Ops
Feb 1, 2025 · Databases

Why MySQL Chooses B+ Trees: From BSTs to Efficient Disk Indexes

This article explains how MySQL's indexing evolved from simple binary search trees through AVL and red‑black trees to B‑trees and finally B+ trees, highlighting the performance and I/O advantages that make B+ trees the preferred index structure for disk‑based databases.

B-TreeData StructuresDatabase Performance
0 likes · 13 min read
Why MySQL Chooses B+ Trees: From BSTs to Efficient Disk Indexes