?
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
Answer & Solution
Correct Answer:
Option
A
Option A: True - Indexes in a database do consume extra storage space because they are separate data structures that store indexed column values for quick retrieval. Additionally, whenever data in the indexed columns change, the index needs to be updated, which adds overhead maintenance time.
Conclusion:
The statement "Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value" is Option A: True. Therefore, the correct answer is True.
Conclusion:
The statement "Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value" is Option A: True. Therefore, the correct answer is True.
Join the Discussion
Login to post a comment or share your explanation.
Login