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:
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.