Lesser the number of indexes means faster inserts, updates and deletes?
sql
Solution
Yes it's correct.
Indexes make select queries run faster. However, whenever you write you your tables, the indexes have to be updated as well, and that takes time.
Problem
I heard that "Lesser the number of indexes means faster inserts, updates and deletes". Is this correct? If yes, then why?