Understand how many indexes to use

Indexes typically help to speed up retrieving data but slow down writing data. The optimal amount of indexes depends on your actual system activity. Putting indexes on everything or having no indexes at all are probably extremes to be avoided—though having many bad indexes is worse than not having any.