Query Bands, Trusted Sessions, and Connection Pooling - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

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.