Indexes are the most important performance feature in any database, and the most commonly misused. Adding the wrong index makes queries slower, not faster. Here's the playbook for indexing -- when an index helps, when it hurts, the index types that go beyond B-tree, and the patterns that turn 30-second queries into 30-millisecond ones.
Engineering Craft
TypeScript, CI/CD, databases, observability -- the skills that make code production-ready.
