Indexes are used to make searches faster - so dropping an index may slow some seek operations and leave others unchanged.
Indexes must be maintained when inserting a record. If an index is dropped then the insertion should be faster.
In most cases updates will be faster with fewer indices.
There may be instances where an update involves a seek - in such cases the update may be slower. There is a better answer than this.
The option of dropping a secondary index to a table is being considered. Which of the following is most likely to be a consequence of dropping the index?
Certain seek operations may be faster.
Certain foreign key relations may not be maintained
More disk space may be required
Certain insertions may be faster
Certain updates may be slower
| ||||
| ||||
|