16.20 - AddQueryListEntry - Teradata Vantage NewSQL Engine

Teradata Vantage™ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

Adds a query to a specified query list where the query is identified by its DBQL ID.

Definition

REPLACE PROCEDURE TDSTATS.AddQueryListEntry(
  IN QueryListName VARCHAR(128) CHARACTER SET UNICODE,
  IN QueryId DECIMAL(18,0)),
  IN Frequency INTEGER)
           .
           .
           .
;

Input Parameters

Parameter Description
QueryListName Name of already created query list. For more information, see AddQueryList.
QueryId DBQL assigned ID for the query as stored in DBC.DBQLogTbl.QueryID.
Frequency Number of logged instances of this same query.

If you specify NULL, the assumed frequency is 1.

Frequency Number of logged instances of this same query.
If the value is NULL, the assumed frequency is 1.

Usage Notes

Typically, queries in need of performance tuning are added to a query list.

You can view the query list data in the TDSTATS.QueryList and TDSTATS.QueryListEntry tables and the names of the query lists in the TDSTATS.QueryList.ListName column.

Example: Using AddQueryListEntry

The following example shows how to add queries 8675309 and 8675325 to the query list named MySlowQueries.

The input parameter value that begins with a colon represents a host variables whose value was populated in a prior call where it served as an output parameter.
CALL TDSTATS.AddQueryList('MySlowQueries');
CALL TDSTATS.AddQueryListEntry('MySlowQueries',8675309,1);
CALL TDSTATS.AddQueryListEntry('MySlowQueries',8675325,1);
CALL TDSTATS.AnalyzeStatsUsage(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MySlowQueries',
'N',AnalysisId, NumEvents);
CALL TDSTATS.AnalyzeStatsUsageReport(:AnalysisId);

Related Topics

For more information on .... See ...
previous created query lists AddQueryList.
the DBC.DBQLogTbl.QueryID column Teradata Vantage™ - Database Administration, B035-1093 or use Teradata Studio or Teradata Studio Express to view details about this column.