17.10 - TableToSparseMapSizingV[X] - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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