To enable fastpath delete processing, statements used to perform unconstrained deletes must be positioned properly. Proper positioning is determined by:
- Position of the statement within the transaction.
- Active session mode of the transaction.
- Type of transaction (ANSI, Implicit, Explicit).