Backend Engineering

Database Indexing — How It Actually Works Under the Hood

Most developers know indexes make queries fast. Few understand why. This post breaks down B-Tree indexing, query planning, and the exact mechanics that turn a 2-second query into a 2ms one.