⟩ What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
Fewer indexes on a table mean faster inserts/updates. More indexes mean faster, more specific WHERE clauses possibly without index merges.