Row-Level DDL Locking Considerations

Data Definition Language (DDL) changes (for example, CREATE INDEX, DROP INDEX, and ALTER TABLE ADD, ALTER, or DROP) to an RLV-enabled table require an exclusive table-level lock. For DDL events, the locking behavior for an RLV-enabled table is the same as for an IQ main store table: the writing connection has an exclusive lock on the table. When BLOCKING is set to ON, all competing DML and DDL transactions against the table are blocked until the DDL changes are committed. When BLOCKING is set to OFF, the competing transaction will immediately fail the lock request.

Related concepts
Schema Locks
Row Locks
Write-Intent Locks
Table-Level DML Locking Considerations