Fast Path INSERT … SELECT Requests - Teradata Database

Fast Path INSERT … SELECT Requests

There are several restrictions that must be observed in order for the high performance fast path optimization to succeed in a multistatement request.

These rules are as follows:

The target table must be empty.

All INSERT statements in the multistatement request must have the same target table.

Only INSERT statements can be included in the request.

If you insert other statement types into the multistatement request, the fast path optimization does not occur (only the first INSERT … SELECT in the series is optimized) and performance degrades accordingly.