Oracle DBA Interview Question:

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?

Submitted by: Administrator

Fewer indexes on a table mean faster inserts/updates. More indexes mean faster, more specific WHERE clauses possibly without index merges.
Submitted by: Administrator