Index locking

Index locking

Index locking is a procedure in which running one task on a database table blocks all access by other tasks to the entire table. With index locking it may be necessary to lock the index build for a column, not just the data items themselves. Index locking prevents conflicts between functions by ensuring that a table is not modified while a function is attempting to use it.

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:
* Small tables with index levels no higher than 3 are being used.
* Possible modifications to the root page of an index are envisioned.


Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать реферат

Look at other dictionaries:

  • Index (database) — A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and increased storage space. Indexes can be created using one or more columns of a database table,… …   Wikipedia

  • locking up — index commitment (confinement) Burton s Legal Thesaurus. William C. Burton. 2006 …   Law dictionary

  • Locking differential — A locking differential, diff lock or locker is a variation on the standard automotive differential. A locking differential may provide increased traction compared to a standard, or open differential by restricting each of the two wheels on an… …   Wikipedia

  • Locking, North Somerset — infobox UK place country = England latitude= 51.3309 longitude= 2.9108 official name= Locking civil parish= population = 2,144 [cite web | title=2001 Census data | work=North Somerset Council | url=http://www.n… …   Wikipedia

  • Mode-locking — is a technique in optics by which a laser can be made to produce pulses of light of extremely short duration, on the order of picoseconds (10−12 s) or femtoseconds (10−15 s). The basis of the technique is to induce a fixed phase… …   Wikipedia

  • CPU locking — is the process of permanently setting a CPU s clock multiplier. AMD CPUs are unlocked in early editions of a model and locked in later editions, but nearly all Intel CPUs are locked and recent models are very resistant to unlocking to prevent… …   Wikipedia

  • Color-flavor locking — (CFL) is a phenomenon that is expected to occur in ultra high density quark matter. The quarks form Cooper pairs, whose color properties are correlated with their flavor properties in a symmetric pattern. According to the standard model of… …   Wikipedia

  • Color–flavor locking — (CFL) is a phenomenon that is expected to occur in ultra high density quark matter. The quarks form Cooper pairs, whose color properties are correlated with their flavor properties in a symmetric pattern. According to the standard model of… …   Wikipedia

  • Extensible Storage Engine — For JET Red storage engine of Microsoft Access, see Microsoft Jet Database Engine. For the teacher s term, Exceptional education. Extensible Storage Engine (ESE), also known as JET Blue, is an Indexed Sequential Access Method (ISAM) data storage… …   Wikipedia

  • Holden Apollo — (JM) Manufacturer Toyota Production 1989–1996 …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”