Home | Previous Page | Next Page   Managing Tables and Indexes > Planning and Managing Tables >

Specifying a Table Lock Mode

The lock mode of a table determines what portion of a table is locked when any row is accessed. The default lock mode is PAGE, which locks the data page that contains the accessed row until the transaction is complete.

When you create or alter a table, you can set its lock mode to TABLE, PAGE, or ROW:

Tip:
To lock more than one row when Cursor Stability is in effect, set ISOlation_LOCKS to a number greater than 1. If you set ISOlation_LOCKS to a number greater than 1, row buffering is more efficient, but concurrency might be reduced.

For information about the relation of the table lock-mode to the index lock mode, see Specifying the Lock Mode for Indexes.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]