A DELETE statement sets a WRITE lock for the table, partitions, or row.
For a SELECT subquery, the lock depends on the isolation level for the session and whether the subquery is embedded within a SELECT or DELETE statement.
| Transaction Isolation Level | Default Locking Severity for Outer SELECT and Ordinary SELECT Subquery Operations | Default Locking Severity for SELECT Operations Embedded Within an UPDATE Request |
|---|---|---|
| SERIALIZABLE | READ | READ |
| READ | ||
| READ UNCOMMITTED | READ | |
| READ UNCOMMITTED | ACCESS |
For more information, see: