Index Key Value Locking

What
Index key value locking is a technique to solve the? Phantom Problem. It prevents the phantom problem by preventing the effects of insertions and deletes while performing reads and writes

Strategy

 * 1) If there is an index on the selection predicate
 * 2) Lock the index pages that contain references to the data (assuming alternative 2). Note that we lock these pages whether there is actually data that matches our selection predicate
 * 3) Otherwise, we lock all pages and the file/table so that no new records can be added