A nontemporal delete, also referred to as vacuuming the table, physically deletes the qualifying rows from the table.
All rows, both open and closed, are considered for qualification conditions specified in the DELETE statement. If multiple transaction-time tables are referenced, they are joined using nonsequenced select semantics.
If the table being deleted has valid time, both valid and rows that are no longer valid are considered for qualification conditions specified in the query.
The only difference between a nonsequenced delete and a nontemporal delete on a table with transaction time is that a nonsequenced delete performs a logical delete of rows whereas a nontemporal delete performs a physical delete of rows.