Multiple-statement requests are a database feature in which multiple SQL statements are bundled together and treated as a single parsing and recovery unit, as the following graphic shows:
These single-AMP multiple-statement requests are run in parallel, and are therefore processed efficiently. Multiple-statement requests are application-independent and can improve performance in multiple ways, especially in improving response times for the combined statements.
The benefits of multiple-statement requests include the following:
- Communication overhead is reduced
- One parser-optimization process is performed instead of multiple ones
- Greater inter-request parallelism is possible