Oracle DBA Question: Download Oracle DBA PDF

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?

Tweet Share WhatsApp

Answer:

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

Download Oracle DBA PDF Read All 50 Oracle DBA Questions
Previous QuestionNext Question
Why is SQL*Loader direct path so fast?What is the difference between RAID 5 and RAID 10? Which is better for Oracle?