Why does an apparently simple optimization often become a system’s first real architectural decision?

Explore how database indexes represent one of the first architectural tradeoffs by prioritizing query performance over modification cost.