Oracle DB Optimization Question:

Download Job Interview Questions and Answers PDF

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.

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?