15.10 - AddQueryListEntry - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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

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

Parameter

Description

QueryListName

Name of already created query list. For more information, see “AddQueryList” on page 609.

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.

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.

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

Note: 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);
 

For more information on ....

See ...

previous created query lists

“AddQueryList” on page 609

the DBC.DBQLogTbl.QueryID column

Database Administration or use Teradata Studio or Teradata Studio Express to view details about this column.