Oct 3, 2018

Database indexes may take up more space and decrease performance on inserts, deletes, and updates.

However, if your table has more than 100 rows, they can considerably reduce select query execution time.