Specifies the cost profile used by Teradata Database. A cost profile is a suite of system-specific values that are used by Teradata Database to make various determinations, such as calculating the lowest-cost (fastest, most efficient) steps that will satisfy an SQL query on a particular combination of system hardware and Teradata Database release.
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.|
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.
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.