17.00 - LIMIT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Various boundary conditions for query logging.

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 “Tracking Query Behavior with Database Query Logging” in Teradata Vantage™ - Database Administration, B035-1093.

Number of SQL characters to capture, where n is the number of characters from 0 through 10,000. The default is 200.
SUMMARY =n1,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.
requests that complete in n or less are counted and queries that exceed n are logged.
n as AMP CPU time, where n represents hundredths of a second.
n as normalized AMP CPU time, where n represents hundredths of a second.
n as elapsed time in seconds.
n as elapsed time, in hundredths of a second. This is the default.
n as a count of total I/Os, where n is specified in the number of I/Os.