Informix Question:
Download Questions PDF

What are the uses of key value locking in Informix?


he 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.

Download Informix Interview Questions And Answers PDF

Previous QuestionNext Question
What is Informix instance?Who conceived and designed the Informix database management system?