Grokking-System-Design
Indexes
Improve the performance of search queries.
Decrease the write performance. This performance degradation applies to all insert, update, and delete operations.