Don’t Over Index
Indices take disk space and write time: Engine must maintain index when value changes or you insert or delete a row.
You may even want to drop index before doing bulk insertion or deletion
Some WHERE’s don’t use index efficiently or at all. (Know your engine!)
Watch MS Access—it indexes any field with “ID” in its name!