17.00 - CDSTableSizeV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Accounting

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The DatabaseName field stores the DatabaseName of the table.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The TableName field stores the TableName of the table.
CurPerm BIGINT --,---,---,---,---,---,--9 The CurPerm field stores the Current Physical Size of the table in bytes.
CurPermWithoutFallback BIGINT --,---,---,---,---,---,--9 The CurPermWithoutFallback field stores the Current Physical Size of the table without fallback in bytes.
CurPermCDS DECIMAL(28,3) --(25).9(3) The CurPermCDS field stores the Logical (CDS) Size of the table in bytes. It excludes Fallback subtable.
CompressionFactor FLOAT -9.99999999999999E-999 The CompressionFactor field stores 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 The LastCollectTimeStamp field stores the Last statistics collection time stamp.
CurrentTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS The CurrentTimeStamp field stores the Current TimeStamp value.
IsValid VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) The IsValid field indicates if for the table collect stats has been run or not.