16.20 - Example: Handling Short Queries - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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;