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