Index Locking Article Index for
Index 		 

Information About

Index Locking
  CATEGORIES ABOUT INDEX LOCKING
   
data management
   
transaction processing
   
APPAREL
BABY
BEAUTY
BOOKS
CAR TOYS
CELL PHONES
DVD'S
ELECTRONICS
GOURMET FOOD
GROCERIES
HEALTH & PERSONAL
HOME & GARDEN
JEWELRY
MUSIC
MUSIC INSTRUMENTS
OFFICE PRODUCTS
SOFTWARE
SPORTING GOODS
TOOLS & HARDWARE
TOYS
VIDEO GAMES
SHOPPING HOME
MORE SHOPPING...




INDEX LOCKING

Index locking blocks all access by other tasks to the entire table in a Database . With Index locking you may want to lock the index build for a Column , not just the data items themselves

The circumstances where it is necessary to index lock include:
  • Adding a new level to the root page

  • Shrinking the root page

  • Splitting or shrinking the immediate child of the root page, causing an update on the root page


Circumstances where it is not necessary to Index lock include where:
  • You have small tables with index levels no higher than 3.

  • You envision possible modifications to the root page of an index


An example of doing an Aggregate Function (sum of salary field)
  • update happens along the way

  • result depends on the order of interleaving

  • best to lock the index as well as the record.