TableToSparseMapSizingV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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