Purpose
Specifies the cost profile used by Teradata Database. 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. Cost profiles should be set up and modified only by Teradata Support Center personnel.
Field Group
General
Valid Range
0 through 32760
| IF CostProfileId is… | THEN… |
|---|---|
| 0 | Teradata Database uses the default cost profile for the current combination of hardware and Teradata Database release. The default may differ from release to release, so this field should remain set to zero under most circumstances. |
| greater than 0 | Teradata Database uses the cost profile identified by the specified number. |
Default
0
Changes Take Effect
For new sessions after the DBS Control Record has been written. Changing this setting does not cause any running sessions to change cost profiles.
Usage Notes
The CostProfileId field is preserved across upgrades. If the field is set to anything other than zero, it can result in an inappropriate cost profile being used when the system is upgraded.