AddQueryList | Application Programming Reference | Teradata Vantage - AddQueryList - Advanced SQL Engine - Teradata Database

Application Programming Reference
Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
hvk1593628831140.ditamap
dita:ditavalPath
hvk1593628831140.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantage™

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.