Multistatement requests are a Teradata Database feature in which multiple SQL statements are bundled together and treated as a single parsing and recovery unit, as illustrated by the following graphic:
Because they are run in parallel, these single‑AMP multistatement requests are processed with great efficiency. Multistatement requests are application‑independent and can improve performance in a variety of ways. They are particularly useful in improving response times for the combined statements.
The benefits of multistatement requests include the following: