Locking a table for the duration of a transaction You can explicitly lock a table for the duration of a transaction with the LOCK TABLE statement. LOCK TABLE statement Lock escalationby user

This is useful if you know in advance that an entire table should be locked and you want to save the resources required for obtaining row locks until the system escalates the locking. For information about this feature, see "LOCK TABLE statement" in the .