16.10 - WorkloadQueries - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

Function of WorkloadQueries

Captures the queries that belong to the workload named by WorkloadID.

WorkloadQueries Table Definition

The following CREATE TABLE request defines the WorkloadQueries table:

CREATE TABLE WorkloadQueries(
  WorkloadID           INTEGER NOT NULL,
  QueryID              INTEGER NOT NULL,
  Frequency            INTEGER NOT NULL)
PRIMARY INDEX(WorkLoadID)
UNIQUE INDEX(WorkloadID, QueryID);

Attribute Definitions for WorkloadQueries

The following table defines the WorkloadQueries table attributes:

Attribute Definition
WorkloadID
  • The workload ID that identifies the data in the row.
  • NUPI for the table.
  • One half of the USI column set for the table.
QueryID
  • Unique qualifier for a query. Used to map it to the workload.
  • One half of the USI column set for the table.
Frequency Indicates the number of times the query is typically performed in the workload.