17.10 - Query Bands, Trusted Sessions, and Connection Pooling - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

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 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.

Trusted sessions do not change the handling of session parameters in connection pooling by default. Note the following restrictions for connection pooling with Vantage. Because it is not possible to reset a connection to Vantage, 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

For information about how to change session parameters, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.