TableToSparseMapSizingV[X] - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Category: TDMaps

Database: TDMaps

View Column Data Type Format Description
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 or join 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 must 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 current map is contiguous, S if 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