AddQueryList | Application Programming Reference | Teradata Vantage - 17.10 - AddQueryList - 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)

Creates a new query list with a user specified name which can be passed to AnalyzeStatsUsage for analysis.

Syntax

REPLACE PROCEDURE TDSTATS.AddQueryList (
  IN QueryListName VARCHAR(128) CHARACTER SET UNICODE
)
  ...
;

Syntax Elements

QueryListName
Name of the query list.
QueryListName must be unique among all query lists stored in the TDSTATS database.

Usage Notes

After a new query list is created, you can call the AddQueryListEntry external stored procedure to add queries to a list.

Example: Using AddQueryList

The following example shows how to create a list consisting of two queries and analyze statistics usage on them.

The input argument value that begins with a colon represents a host variable whose value was populated in a prior call where it served as an output argument.

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 ..
the AnalyzeStatsUsage external stored procedure AnalyzeStatsUsage.
adding queries to your list AddQueryListEntry.