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.
|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.