Answers

Question and Answer:

  Home  Oracle DBA

⟩ 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.

 211 views

More Questions for you: