17.05 - limit_item - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Specifies boundary conditions for query logging:

limit_item Description
SQLTEXT=n Number of SQL characters to capture, where n is the number of characters from 0 through 10,000. The default is 200.
SUMMARYn1,n2,n3 Requests are grouped by duration intervals or number of I/Os, each group is counted, and the count results are stored.
You can specify up to 3 intervals and a fourth interval is created by default as anything longer than n3:
  • 0 through n1
  • n1 through n2
  • n2 through n3
  • greater than n3
SUMMARY cannot be used with LIMIT THRESHOLD or logging options.
THRESHOLD=n Requests that complete in n or less are counted and queries that exceed n are logged.
CPUTIME n as AMP CPU time, where n represents hundredths of a second.
CPUTIMENORM n as normalized AMP CPU time, where n represents hundredths of a second.
ELAPSEDSEC n as elapsed time in seconds.
ELAPSEDTIME (default) n as elapsed time, in hundredths of a second.
IOCOUNT n as a count of total I/Os, where n is specified in the number of I/Os.

Specifying any of the limit options can have a performance impact on your system.

For complete descriptions of these options and their option modifiers. See Teradata Vantage™ - Database Administration, B035-1093.