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

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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