Use a correlated subquery for access.
The CORSUB operation provides access by a correlated subquery.
Perform a DELETE WHERE CURRENT OF CURSOR operation.
Remove rows from a table or view.
A delete construct contains a DELETE node and one of the following: table space scan, single-index access, or multiple-index access.
Represents a direct fetch data using ROWID.
ROWID is used as a search condition. This is the most efficient was to access a base table if a ROWID-type column is defined within the table.