DELETE Statement is in the Last Request - Teradata Database

If a DELETE statement is in the last request of a transaction and the following conditions are met, the delete is optimized to delete entire row partitions:

The ANSI mode and Teradata mode conditions for fastpath delete processing are satisfied, with the exception that a deferred partition DELETE can be followed by another statement that references the same target table.

The target table is not defined with referential integrity.

This avoids transient journaling of each row deleted from those row partitions.