Oracle DB Optimization Question:

Explain some disadvantages of the Indexes?

Oracle Database Optimization Interview Question
Oracle Database Optimization Interview Question

Answer:

Indexes improve query performance but it slows down data modification operations.
Indexes consume disk space.


Previous QuestionNext Question
Tell me what are the types of Indexes?Tell me what is Index tuning?