Parallel Teradata Database Operations - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Teradata Database automatically manages processors to optimize the processing of an application‑initiated Teradata SQL request. No special programming is necessary to take advantage of these parallel processing capabilities. 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 programming techniques that enable an application to overlap the processing of several Teradata SQL requests:

  • Multi‑statement management
  • Multi‑thread management
  • Multi‑session management