17.10 - Using SET SESSION Statements with Connection Pooling - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
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 Vantage. Connection pooling improves performance by eliminating the overhead associated with establishing a new connection to Vantage for each request submitted by a client application end user.

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