I have a sql, which deletes some records in a table. The table has more than 100 millions records. The sql takes more than 30 seconds to finish execution. Will this sql lock the table? The sql deletes records based on primary key. Below is my sql: DELETE FROM DISPLAY_LOG WHERE LOG_ID < @primary_key LOG_ID is the primary key of the table. The type of this field is INT.