Sahil
Sahil

Reputation: 9496

Disadvantages of having many Indexes in a SQL database?

I am a database newbie and I am working on the design of my database. For efficient operation of my application I need indexes on half of my columns since with that my look will be logarithmic time.

But is there any disadvantage of having multiple indexes in a same table?

Upvotes: 3

Views: 4383

Answers (1)

Stanley
Stanley

Reputation: 1441

  • insert/update performance when indexed columns are modified will be worse
  • more indexes will use more disk space

Upvotes: 9

Related Questions