What is database indexing trade-off?

Indexes improve reads but slow down writes.

Every index must be updated on insert/update/delete, increasing write latency and storage usage. The trade-off depends on read vs write workload balance.