Indexes require additional maintenance during writes.
When you insert or update data, the database must also update the index, which takes extra time. For instance, adding a new product to an indexed 'products' table means the index needs updating, slowing down the insert operation. In the context of an e-commerce app, if new products are frequently added, consider the trade-off between read speed and write efficiency.