Maintaining indexes during updates may require what?

Maintaining indexes during updates may require what?

• A. Updating the index is not needed
• B. Updating the index as well
• C. Updates are blocked
• D. Indexes must be rebuilt from scratch on every update

Answer: (B)

Indexes must be kept in sync with the data. When a row is updated, any index that includes that data needs to reflect the change so queries using the index return correct results and stay fast. This is usually done through incremental maintenance—the database updates only the affected index entries rather than rebuilding the entire index after each update. Rebuilding from scratch on every update would be extremely inefficient and isn’t how modern systems operate. Updates aren’t typically blocked; they proceed with the index being maintained alongside the data. So, the necessary action during updates is to update the index as well.

Indexes must be kept in sync with the data. When a row is updated, any index that includes that data needs to reflect the change so queries using the index return correct results and stay fast. This is usually done through incremental maintenance—the database updates only the affected index entries rather than rebuilding the entire index after each update. Rebuilding from scratch on every update would be extremely inefficient and isn’t how modern systems operate. Updates aren’t typically blocked; they proceed with the index being maintained alongside the data. So, the necessary action during updates is to update the index as well.