17.05 - Example: Handling Short Queries - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

Log request information with an SQL text limit for user_1 and user_2:

     BEGIN QUERY LOGGING LIMIT THRESHOLD=4 AND SQLTEXT=100 
     ON user_1, user_2;

The following table describes the logging behavior for various request completion times for the specified threshold.

Query Completion Time in Seconds Log Table …
  ≤   4 DBQLSummaryTbl.

The requests are recorded only as counts in the QueryCount column.

  > 4 DBQLogTbl.

The logged SQL text is limited to 100 characters.

Log requests for user_1 and user_2:

     BEGIN QUERY LOGGING WITH SQL, STEPINFO, OBJECTS LIMIT THRESHOLD=10
       CPUTIME ON user_1, user_2;

You can specify equivalent query logging using various methods. For example, specify THRESHOLD with the SQL, STEPINFO, and OBJECTS options individually:

     BEGIN QUERY LOGGING WITH SQL LIMIT THRESHOLD=10 CPUTIME 
       ON user_1, user_2;
     BEGIN QUERY LOGGING WITH STEPINFO LIMIT THRESHOLD=10 CPUTIME 
       ON user_1, user_2;
     BEGIN QUERY LOGGING WITH OBJECTS LIMIT THRESHOLD=10 CPUTIME 
       ON user_1, user_2;