Category: TDMaps
Database: TDMaps
View Column | Data Type | Format | Comment |
---|---|---|---|
DataBaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the database |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the table, join index, or hash index |
PeakDiskSpace | BIGINT | -(19)9 | An estimate of the amount of peak disk space all the primary rows take determined by looking at peak space and subtracting out an estimate for the table header. |
CurrentDiskSpace | BIGINT | -(19)9 | An estimate of the amount of current disk space all the primary rows take determined by looking at the current space and subtracting out an estimate for the table header. |
DataSize | BIGINT | -(19)9 | An estimate of the amount of space all the primary rows take considering the statistics and average row size. |
RecommendedMap | VARCHAR(26) LATIN NOT CASESPECIFIC | X(26) | The map the object should be in |
CurrentMap | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The map the object is currently in |
MapOk | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | Y if data estimated for the table is appropriate for the map the table is currently in, N otherwise |
CurrentMapKind | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | C if the current map is contiguous, S if it is sparse |
CurrentMapNumOfAMPs | SMALLINT NOT NULL | ---,--9 | The number of AMPs in the map the object is in |
ProtectionType | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | F if the table is fallback protected, N if not |