15.10 - Using SET SESSION Statements with Connection Pooling - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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 Teradata Database. Connection pooling improves performance by eliminating the overhead associated with establishing a new connection to Teradata Database for each request submitted by a client application end user.

Because it is not possible to reset a connection to Teradata Database, 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