AddQueryListEntry Stored Procedure | Application Programming Reference | Vantage - 17.10 - AddQueryListEntry - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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


  IN QueryId DECIMAL(18,0)),
  IN Frequency INTEGER

Syntax Elements

Name of already created query list. For more information, see AddQueryList.
DBQL assigned ID for the query as stored in DBC.DBQLogTbl.QueryID.
Number of logged instances of this same query.
If you specify 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);
'N',AnalysisId, NumEvents);
CALL TDSTATS.AnalyzeStatsUsageReport(:AnalysisId);

Related Information

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.