limit_item - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.