LIMIT - Advanced SQL Engine - Teradata Database

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.

SQLTEXT= n

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.

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

n as elapsed time, in hundredths of a second. This is the default.

IOCOUNT

n as a count of total I/Os, where n is specified in the number of I/Os.