What are the disadvantages of using indexes in database?

Answer 1

Some drawbacks of using indexes are:

1. Growing disk space:

Indexes are stored on the disk, and the amount of space required will depend on the size of the table, and the number and types of columns used in the index. However, disk space is generally cheap enough to trade for application performance.

2. Performance hit with heavy data modifications
Any time a query modifies the data in a table (INSERT, UPDATE, or DELETE), the database needs to update all of the indexes where data has changed


Reference: http://odetocode.com/articles/70.aspx