Indexes reduces (not always) the performance of Insert, Update, Delete and SELECT statements.
As a general rule, try to have around 5 indexes per tables, 5 columns per index. This is not a hard and fast rule. Just a general good starting point.
Indexes reduce the performance of SELECT statement even when an index is not being used.
Database Blog 