16.20 - Parallel Processing - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Teradata Database can simultaneously process multiple requests from one or more applications, automatically managing the processors to optimize an application-initiated Teradata SQL request. No special programming is necessary to take advantage of the parallel processing capabilities of Teradata Database.

Performance improvements can be achieved by programming an application to overlap the processing of more than one Teradata SQL request at a time. The following sections discuss three techniques that enable an application to overlap the processing of Teradata SQL requests:

  • Multi-statement management
  • Multi-request management
  • Multi-session management