Short text
Size of input/output buffer used for array operations
Parameter Description
This parameter defines the size of a data area, with which the input and output values of an SQL statement are transferred to the HANA database. It influences in particular the maximum number of records that are brought into the database with an array operation (e.g. array insert) or are read from there (array fetch).
The larger the selected value, the more records can be transferred from or to the database with a single database operation. However the HANA client software also partitions the data to be transported again, so that increasing the value may not necessarily lead to a reduction in network traffic.
Parameter Unit
Bytes
Default Value
1048576 (1 MB )
Database System Restrictions
HDB
