Importance of Specifying Multiple BTEQ Sessions | Basic Teradata Query - 17.00 - Specifying Multiple Sessions - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

BTEQ can establish dedicated database user sessions in sets, so that multiple SQL requests can run in parallel within a given set. This is especially helpful to process a high volume of repetitive tasks whose order does not matter, such as loading a large number of rows onto a database. In this case, having a number of parallel sessions with each session handling some of the requests can substantially speed up operations. See SESSIONS.