The 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: