Database Indexing Deep Dive: B-Trees, Page I/O, and Why Inserts Get Slow

How B-Trees are physically sized, why sequential keys matter, and what actually happens on disk when a query runs — no hand-waving.