When you request multistatement
inserts, SAS first determines how many insert statements it can send
to Teradata. Several factors determine the actual number of statements
that SAS can send—for example, how many:
-
SQL insert statements can fit in
a 64K buffer.
-
data rows can fit in the 64K data
buffer.
-
inserts the Teradata server chooses
to accept.
When you need to insert large volumes of data, you
can significantly improve performance by using MULTISTMT= instead
of inserting only single-row.
If you also specify
DBCOMMIT=, SAS uses the smaller of these: the DBCOMMIT= value and
the number of insert statements that can fit in a buffer as the number
of insert statements to send together at one time.