BTEQ - Specify Multiple sessions in Teradata

You can set the number of sessions for BTEQ to process the queries in parallel manner.
Users come to know the main advantage of BTEQ while specifying the sessions more than one.

If you have multiple set/batch of queries which are independent to each other, then you are absolutely correct to use SET SESSIONS in BTEQ.
For example, if you want to insert 1 lakh records into a database which approximately takes 100 minutes, then SET the sessions to 10.
The time will be (1/10) now compared to of previous insert.


where n is the number of sessions.

n may vary with the workstation.