17.10 - EnableSetCostProfile - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
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

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.