15.10 - CostProfileValues_v - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

ProfileName

CHAR(30) LATIN

NOT CASESPECIFIC

NOT NULL

X(15)

CostProfiles.ProfileName (USI)

ProfileId

INTEGER

NOT NULL

-----9

CostProfiles.ProfileId (UPI)

ConstName

CHAR(64) LATIN

NOT CASESPECIFIC

NOT NULL

X(30)

ConstantDefs.ConstName

ConstId

INTEGER

NOT NULL

-----9

ConstantDefs.ConstId (Composite USI)

ConstCat

CHAR(1)LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

ConstantDefs.ConstCat

ConstVal

FLOAT

----,---,--9.9999

ConstantValues.ConstVal

ConstDesc

VARCHAR(2048) LATIN

NOT CASESPECIFIC

X(2048)

ConstantDefs.ConstDesc

The following example lists the parameter values for a profile named V2R5_UseSpoolLimit:

SELECT ConstName (TITLE 'Profile Name')
   , ConstId (TITLE 'Id', FORMAT '--9')
   , ConstVal (TITLE 'Value')
   , ConstCat (TITLE 'Cat')
   FROM DBC.CostProfileValues_v
   WHERE ProfileName = 'V2R5_UseSpoolLimit'
   ORDER BY 4 DESC, 1; <Note T="Result">

Result:

Profile Name                     Id           Value  Cat
------------------------------  ---  --------------  ---
ApplySpoolLimit                  65             1.0  I
OptBitInst                        1            33.0  I
OptBMAndRowInst                   2        98,500.0  I
OptCharFieldInst                  3           261.0  I
OptIndexBlockSize                 4        49,152.0  I
OptMaxBldKeySize                  5         1,000.0  I
OptMaxRowIdsIndex                 6         8,030.0  I
OptNumFieldInst                   7            37.0  I
OptOutputRowInst                  8         1,641.0  I
OptOvhdOfRowCompInst              9           242.0  I
OptRedistributeInst              10        73,389.0  I
OptRowAccessInst                 11           409.0  I
OptRowIdInst                     12        27,139.0  I
OptRowidSize                     13            12.0  I
OptSpoolBlockSize                14       131,072.0  I
OptSynonymInst                   15        27,139.0  I
OptTableBlockSize                16        49,152.0  I
SpoolLimitPercent                73           100.0  I