Performance

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

DML array support performance is superior to emulation using multi-statement requests. Teradata Database can optimize a parameter array request, reducing the request size and number of steps, while increasing the number of possible iterations. The best performance is seen for small parameter sets where the array pack factor can be increased.