Disadvantage of index

Remember some disadvantages of index

Each index  occupy some extra space on the disk, which means that as the data increases it need some extra space not to store data but to maintain index data also.

Indexes  Slow down the insertion and updation of the table- because index has to maintain the details about the original data , when data is inserted or updated the index will have to updated as well . In case of multiple indexes ,  these multiple indexes will have to be updated on insert and update operation and hence the operations will become slow.