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