17.00 - ActionsV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: TDMaps

Database: TDMaps

View Column Data Type Format Comment
ZoneName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Zone name
Action VARCHAR(24) LATIN NOT CASESPECIFIC NOT NULL X(24) Type of action to perform on the table
Origin CHAR(1) LATIN NOT CASESPECIFIC X(1) Source of this action. 'A' indicates Advisor procedures. 'U' or NULL indicates a user inserted action.
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Database on which the action applies
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Table, Join Index, or Hash Index on which the action applies
SourceMap VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The current map of the table prior to performing the recommended action
DestinationMap VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The target map for performing the specified action against
CoLocateName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Advisor recommended qualified name for COLOCATE USING clause. Applicable only when DestinationMap is defined as SPARSE
ActionSQLText VARCHAR(10000) UNICODE NOT CASESPECIFIC X(10000) The SQL text of the DDL statement that would perform this action. This column is informational only
ActionListName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Named list of actions of which this action is a member of
GroupOrder DECIMAL(18,2) --Z(15)9.99 Common identifier and priority rank of the group in which this action is a member
ActionOrder DECIMAL(10,2) zz9.99 Priority rank of an action within its group. Applicable only for rows whose Action value is 'Alter'
TableSize BIGINT -(19)9 Advisor computed size of the table in bytes at the time of analysis
FractionOfPermDBFree FLOAT -9.99999999999999E-999 fraction of free database space available for the table
UDICnt BIGINT -(19)9 Number of rows Updated, Deleted, or Inserted on this the table by logged SQL statements during the period analyzed
QueryCnt BIGINT -(19)9 Number of logged DML SQL requests referencing the table during the period analyzed
PKJoinCnt BIGINT -(19)9 Number of join steps on this table requiring no data redistribution as recorded by logged DML statements during the period analyzed by the Advisor
LastAlterTimeStamp TIMESTAMP(6) WITH TIME ZONE NOT NULL YYYY-MM-DDBHH:MI:SS.S(6)Z Last modification time on the metadata describing this action
LastAlterUID BYTE(4) NOT NULL X(8) User who last modified the metadata for this action
Issues CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) 'Y' or 'N'. If 'Y', it indicates there is something that administrator may want to check
ActionsTblDescription VARCHAR(1024) UNICODE NOT CASESPECIFIC X(1024) Advisor generated comment providing further explanation for the recommended action