LOCK MODE Options (XPS)

The LOCK MODE options specify the locking granularity of the index.

LOCK MODE Options:
 
              .-NORMAL-.
|--LOCK MODE--+-COARSE-+----------------------------------------|
 

In COARSE lock mode, index-level locks are acquired on the index instead of item-level or page-level locks. This mode reduces the number of lock calls on the index. Use the coarse-lock mode when you know the index is not going to change, as when only read-only operations are performed on the index.

If you specify no lock mode, the default is NORMAL. That is, the database server places item-level or page-level locks on the index as necessary.