Stores user comments about captured plans written using either the Teradata System Emulation Tool or Visual EXPLAIN client utilities.
The following CREATE TABLE request defines the UserRemarks table.
CREATE TABLE UserRemarks(
QueryID INTEGER,
StepID INTEGER,
WorkloadID INTEGER,
RowType CHARACTER(1) CHARACTER SET LATIN NOT CASESPECIFIC
NOT NULL,
SeqNumber INTEGER NOT NULL,
UpdTime TIMESTAMP(6) NOT NULL,
UserName VARCHAR128 CHARACTER SET UNICODE
NOT CASESPECIFIC NOT NULL,
Remarks VARCHAR31000 CHARACTER SET UNICODE
NOT CASESPECIFIC NOT NULL)
PRIMARY INDEX (QueryID, UserName);
The following table defines the UserRemarks table attributes.
Attribute |
Definition |
|||
QueryID |
The ID of the query about which remarks are being saved. Partial NUPI for the table. |
|||
StepID |
The ID of the step about which remarks are being saved. |
|||
WorkloadID |
The ID of the workload to which the query belongs. |
|||
RowType |
Specifies which utility collected the remarks and whether they were saved or generated. |
|||
SeqNumber |
A system‑generated number (1 for the first row, 2 for second, and so on) to indicate the sequential order of remarks. |
|||
UpdTime |
The timestamp when the remark was last updated. |
|||
UserName |
The UserName of the user who last updated the row. Partial NUPI for the table. |
|||
Remarks |
The remarks of the step or query. |
See the following books for more information about the Teradata System Emulation Tool and Teradata Visual Explain utilities.