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.
Represents access by XML DOCID index scan.
Denotes the EXCEPT operation.
This operation returns rows in the outer table only and eliminates redundant duplicate rows.
