Teradata Database uses fastpath delete processing when the target table has a simple
or aggregate join index that is one of the following:
Single‑table join index.
Multitable join index defined with an inner join.
Multitable join index where the table being deleted is the outer table of an outer
join.
This includes the following statements:
A DELETE ALL or unconditional DELETE statement on a table that has a simple or aggregate
join index. Teradata Database uses fastpath delete processing for the base table and
its join index.
A conditional DELETE statement on a table that has a simple or aggregate join index.
Teradata Database uses fastpath delete processing only for the join index if the DELETE
condition covers the entire index.