EnableSetCostProfile - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Publication Date
June 2025
Content Type
Administration
Configuration
Support
Publication ID
B035-1102-200K
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
ft:sourceId
dita
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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

General

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.

Default

0

Changes Take Effect

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