Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

Any kind of index usually slows down writes, because the index also needs to be updated every time data is written.