Multiple Sessions Setting in Teradata Tools and utilities
I see that we can set the number of sessions in BTEQ. How does this multiple session setting work in BTEQ?
If I run a Batch script in BTEQ with number of sessions set to more than 1, Will I see the benefit in query run-time? How does 'set sessions ' setting work in BTEQ and in general how does multiple session setting work in Teradata?
Re: Multiple Sessions Setting in Teradata Tools and utilities
In general, multiple sessions allow for parallelism when transferring data between the client and the Teradata database.
In the case of BTEQ, multiple sessions are only useful in conjunction with .REPEAT, to allow multiple .IMPORT records to be processed concurrently. The request corresponding to each input record will be assigned to one of the sessions, round-robin.