It is important to understand when indexes are needed, how they work, and different index types. Indexes (can) speed selects, but slow writes to the db.