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?
- 1 Answers
- 721 Views
- I also Faced
- E-Mail Answers
Answer / Anjana Yadav
Having multiple indexes can lead to faster data retrieval due to reduced I/O operations. However, more indexes can increase CPU consumption during insert, update, and delete operations because of the need to maintain the indexes. Having few indexes can result in slower query performance but better write performance due to less overhead. It is best to have as few indexes as possible while still providing acceptable query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the five main functions of a database administrator?
What degree do database administrators need?
Tell me about standby database? What are some of the configurations of it?
How many dba can you have?
Explain the wait events in statspack report 'db scattered read'?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
What should a dba know?
What is the dba role in oracle?
What are the main functions of dba?
Why do we need a database?
What is pga_aggregate_target?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
Oracle General 
