17.10 - EnableSetCostProfile - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Controls whether the system cost profile can be changed for purposes of system emulation and special-case system tuning. A cost profile is a suite of system-specific values (cost profile constants) that Vantage uses for Optimizer costing coefficients, enabling and disabling certain features, and other system settings. A cost profile can apply system-wide or be associated with a PROFILE and apply only to users assigned that PROFILE.

This field should be changed only under the direction of Teradata Support Center personnel.

Field Group


Valid Settings

Setting Description
0 Disable changing system cost profile.
1 Enable changing system cost profile for SESSION and REQUEST levels.
2 Enable changing system cost profile at all levels.



Changes Take Effect

For new sessions after the DBS Control Record has been written.