DB2 10.5 for Linux, UNIX, and Windows

DELETE operator

This operator represents the deletion of rows from a table.

Operator name: DELETE

Represents: The deletion of rows from a table.

This operator represents a necessary operation. To improve access plan costs, concentrate on other operators (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.