15.00 - Query Bands, Trusted Sessions, and Connection Pooling - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Query Bands, Trusted Sessions, and Connection Pooling

Connection pooling is a technique for sharing server resources among various requesting client applications. It enables multiple clients 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.

Trusted sessions do not change the handling of session parameters in connection pooling by default. Note the following restrictions for connection pooling with Teradata Database. Because it is not possible to reset a connection to Teradata Database, you must not change any of the following session parameters during a trusted session, because any changes to them are then inherited by the next user of the connection.

  • Character set
  • Collation
  • Database
  • Dateform
  • Default Date Format
  • Timezone
  • Transaction Isolation Level
  • See “SET SESSION” on page 876 for information about how to change session parameters.