AddQueryListEntry - Teradata Database - Teradata Vantage NewSQL Engine

Application Programming Reference

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
vwf1492987142269.ditamap
dita:ditavalPath
changebar_rev_16_20_exclude_audience_ie.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantage™

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.