What an index costs you

• A

  The database has a hard limit on the number of indexes per table

• B

  Indexes become inconsistent with the table and need rebuilding

• C

  Every insert, update and delete must also update every index, so writes get slower

• D

  Queries become slower because the planner now has many more options to consider