The search key of an item must not change for as long as the item is stored in a table.

Question

Quizplus · Accepted Answer

This is because the search key is used to uniquely identify the item, and changing it would make it difficult to retrieve or update the data. If the search key needs to be changed, it would require updating all the table records that reference it, which can be error-prone and time-consuming. Therefore, it is important to carefully choose the search key and avoid changing it once it has been set.

The Search Key of an Item Must Not Change for as Long