TableToSparseMapSizingV[X] - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

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