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 |
|
| QueryID |
|
| Frequency | Indicates the number of times the query is typically performed in the workload. |