Oracle DBA Question: Download Questions 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.
Download Oracle DBA Interview Questions And Answers
PDF
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? |