This
node represents the deletion of rows from a table.
Node name: DELETE
Represents: The
deletion of rows from a table.
This node 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.