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 |