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.
- THRESHOLD=n
- Requests that complete in n or less are counted and queries that exceed n are logged.