17.10 - CostProfileId - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Specifies the cost profile used by Vantage. 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. 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 Vantage uses the default cost profile for the current combination of hardware and database release. The default may differ from release to release, so this field should remain set to zero under most circumstances.
greater than 0 Vantage 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.