16.10 - Array Support - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

The Array Support feature allows DML requests containing only a single statement to be executed once for each of multiple rows of input data, each row specified being one of the members of the array. The DML must be contained within an APPLY statement that includes Stream operator and does not set ArraySupport to Off.

Use of array support improves performance by:

  • Increasing the amount of data that can be sent per request from a total of approximately 64 KB to a total of approximately 1 MB, with a limit of 64 KB per input data row.
  • Improvements in internal Teradata Database processing as a result of using such requests.