Index Locking

The circumstances where it is necessary to index lock include:

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:

	CATEGORIES ABOUT INDEX LOCKING

	data management

	transaction processing

Information About