Using SET SESSION Statements with Connection Pooling
Connection pooling is a technique for sharing server resources among end users of a requesting client application. It enables multiple end users to share a cached set of connection objects that provides access to the Teradata system. Connection pooling improves performance by eliminating the overhead associated with establishing a new connection to the Teradata system for each request submitted by a client application end user.
Because it is not possible to reset a connection to the Teradata system, you should avoid changing any of the following session parameters during a pooled session (including trusted sessions), because these parameter changes are inherited by the next user of the pooled connection.
- Character set
- Collation
- Database
- Dateform
- Default Date Format
- Time zone
- Transaction Isolation Level