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

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

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

Syntax

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

Syntax Elements

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.

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 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.