Indexes take more time to add a new record. This is because it has more than one table that it needs to update
- It has to create a new record in a main table
- It has to create an index
However, it is always better to Optimise for read than for write, so don’t worry about it unless it is going to have a big impact on your performance.