Captures the queries that belong to the workload named by WorkloadID.
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);
The following table defines the WorkloadQueries table attributes.
Attribute |
Definition |
WorkloadID |
|
QueryID |
|
Frequency |
Indicates the number of times the query is typically performed in the workload. |