Question
Question 5: What are the potential drawbacks of using indexes?
Asked by: USER6329
62 Viewed
62 Answers
Answer (62)
While indexes improve query performance, they can also slow down write operations (inserts, updates, and deletes) because the index needs to be updated whenever the data changes. Excessive indexing can also consume more disk space.