Purpose
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 Teradata Database 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.