Lock compatibility

Lock Compatibility Matrix lists compatibility between lock types. + means compatible, - means incompatible.

Table 1. Lock Compatibility Matrix
  Shared Update Exclusive
Shared

+

+

-

Update

+

-

-

Exclusive

-

-

-

Related concepts
Exclusive locks
Shared locks
Update locks
Notes on locking
Related reference
Scope of locks