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?
Answer:
Fewer indexes on a table mean faster inserts/updates. More indexes mean faster, more specific WHERE clauses possibly without index merges.
Previous Question | Next Question |
Why is SQL*Loader direct path so fast? | What is the difference between RAID 5 and RAID 10? Which is better for Oracle? |