DELETE node

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.

Feedback