a technique where the system determines that a lock is unnecessary and skips it entirely. Lock avoidance checks the log to determine whether a row has been committed and whether it is currently being modified. If the row is committed and not in flight, no lock is acquired.