Performance - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
wxs1608578396899.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

DML array support performance is superior to emulation using multi-statement requests. The 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.