The UPDATE statement acquires page locks for each row in the table that is evaluated against the WHERE clause.