Teradata Sessions explained in a few Sentences
What is a Teradata session?
A session is a LOGON of a user on a Teradata system through which one or more sequential transactions can be executed. A LOGOFF statement terminates the session.
What are multiple Teradata sessions (e.g., in BTEQ)?
For Teradata, multiple sessions are like several users (but with the same user credentials). Each session belongs to the same Teradata user and can execute one or more sequential transactions between LOGON and LOGOFF, just like a single session.
What are the multiple Teradata sessions used for?
Multiple sessions make it possible to run multiple tasks in parallel. The aim is to increase performance.
Does the use of Teradata multiple sessions always increase performance?
Not at all. For several sessions (e.g., in a BTEQ script) to increase performance, Rowhash accesses must be made. Rowhash access only occurs if a UPI, NUPI, or USI is used. All other access paths require a table lock, and using multiple sessions does not improve performance.
When does a BTEQ script typically increase performance by using multiple Teradata sessions?
A BTEQ import script can usually increase performance by using multiple sessions. BTEQ export scripts typically do not achieve any performance advantage by using multiple sessions.
How many Teradata sessions should I use?
This isn’t easy to answer and is best determined empirically. What is essential is an access path via the Rowhash (UPI, NUPI, USI). Too few sessions do not bring out the maximum performance. Too many sessions do not bring any more performance advantage after a certain point but increase the administration effort.
For which access paths do multiple sessions not make sense?
For Full Table Scans and NUSI accesses.
Example 1: Multiple Sessions which do not improve performance

Multiple sessions can improve throughput for compatible all-AMP scans or independent tables as well as rowhash access. Benefit depends on workload concurrency and resource contention, not a universal fewer-than-all-AMP rule.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free bookExample 2: Multiple Sessions which do improve performance

In Example 2, each transaction is exclusively active on one AMP, allowing all four AMPs to perform distinct tasks concurrently.
- Multiple sessions can improve throughput for compatible all-AMP scans or independent tables as well as rowhash access. Benefit depends on workload concurrency and resource contention, not a universal fewer-than-all-AMP rule.
- Ideally, enough sessions are available to keep all AMPs equally busy with transactions.
The embedded video’s corresponding all-AMP/no-benefit claim is superseded by the corrected guidance here. Captions were reviewed; historical throughput and diagrams were not independently measured. BTEQ import and export behavior must be evaluated separately.
Need help with query performance or platform costs?
Diagnose plans, skew, spool pressure and expensive workloads. Agree a baseline and acceptance criteria before making changes.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free book
excellent topic
Nice article about sessions.. examples helps to clear the concept. Thanks for sharing
Thank you very much!
Thank you very much!