15.00 - Multistatement Requests - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Multistatement Requests

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:

  • Communication overhead is reduced
  • One parser‑optimization process is performed instead of several
  • Greater inter-request parallelism is possible