5.26 Explain the lock table statement (continued)
Key points (continued)
You cannot weaken an implicit locking structure using the LOCK TABLE
statement:
- There is no benefit when a PRIVATE table is locked in SHARE or SHARE UPDATE
mode. Your transaction will still acquire an X lock at the
table level when any access to the table is made. In fact, your
LOCK TABLE
request will actually obtain an X lock.
- There is no benefit when a PUBLICREAD table is locked in SHARE UPDATE mode.
Your transaction will still acquire an X lock at the table level
when any write to the table is made.
Page last updated on November 29, 1995
|
Printable version
