CDSTableSizeV - 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: Accounting

Database: DBC

View Column Data Type Format Description
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Database name of the table.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Table name of the table.
CurPerm BIGINT --,---,---,---,---,---,--9 Current Physical Size of the table in bytes.
CurPermWithoutFallback BIGINT --,---,---,---,---,---,--9 Current Physical Size of the table without fallback in bytes.
CurPermCDS DECIMAL(28,3) --(25).9(3) Logical (CDS) Size of the table in bytes. Excludes Fallback subtable.
CompressionFactor FLOAT -9.99999999999999E-999 The X value which is 1:X times when compared to the physical size of the table.
LastCollectTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Last statistics collection timestamp.
CurrentTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Current timestamp value.
IsValid VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) Indicates if for the table collect stats has been run or not.