17.00 - TableToSparseMapSizingV[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
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