InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are The Uses Of Key Value Locking In Informix? |
|
Answer» The database server uses a concept called key-value locking to lock the deleted row. When the database server DELETES a row, key values in the indexes for the table are not REMOVED immediately. Instead, each key value is MARKED as deleted, and a lock is placed on the key value. One of the most IMPORTANT uses for key-value locking is to assure that a unique key remains unique through the end of the TRANSACTION that deleted it. The database server uses a concept called key-value locking to lock the deleted row. When the database server deletes a row, key values in the indexes for the table are not removed immediately. Instead, each key value is marked as deleted, and a lock is placed on the key value. One of the most important uses for key-value locking is to assure that a unique key remains unique through the end of the transaction that deleted it. |
|