Oracle DB Optimization Question:
Download Questions PDF

Explain some disadvantages of the Indexes?

Answer:

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

Download Oracle Database Optimization Interview Questions And Answers PDF

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