Each index will slow down writing data.
Each index will slightly slow down the planning request.
Each index how much something weighs.
Suitable for a query, the index will significantly speed up the query.
Suitable for FK index will speed up this FK check when the write operations.
Index to frequently updated field will turn off hot update optimization.