Conceptual
Login

B-Tree

A B-tree is a balanced, high-fanout search tree whose nodes are disk pages, keeping millions of sorted keys reachable in three or four page reads; leaves are chained so range scans are sequential. Its sorted order is why B-tree indexes serve equality, ranges, prefix matches, and ORDER BY, but not arbitrary predicates.