16.10 - CostProfileId - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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.

This field should be changed only under the direction of 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.