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 database processing as a result of using such requests.