This
node represents the deletion of rows from a table.
Node name: DELETE
Represents: The
deletion of rows from a table.
This operator represents a
necessary operation. To improve access plan costs, concentrate on
other nodes (such as scans and joins) that define the set of rows
to be deleted.
Performance Suggestion: - If you are deleting
all rows from a table, consider using the DROP TABLE statement or
the LOAD REPLACE command.