17.00 - CostProfileValues_v - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
June 2020
Programming Reference

Category: Operations

Database: DBC

View Column Data Type Format Comment
ProfileName CHAR(30) LATIN NOT CASESPECIFIC NOT NULL X(15) ProfileName is the unique name assigned to this cost profile instance in the system.
ProfileId INTEGER NOT NULL -----9 ProfileId is the unique number assigned to the cost profile instance in the system.
ConstName CHAR(64) LATIN NOT CASESPECIFIC NOT NULL X(30) ConstName is the name associated with this constant.
ConstId INTEGER NOT NULL -----9 ConstId identifies this constant within the cost profile.
ConstCat CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) ConstCat is the category for this constant. For Legacy and Subops profile types, the constant categories are: C-Cost Method Parameter, I-Initialization Parameter.
ConstVal FLOAT ----,---,--9.9999 ConstVal is the specified value of the constant in this cost profile instance. A NULL value implies there is no specified value.
ConstDesc VARCHAR(2048) UNICODE NOT CASESPECIFIC X(2048) ConstDesc is the description associated with this constant.