EnableCostProfileTLE - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Enables/disables Optimizer Cost Estimation Subsystem (OCES) diagnostics for use in combination with Target Level Emulation (TLE).

This field should be changed only under the direction of Teradata Support Center personnel.

Field Group

General

Valid Settings

Setting Description
TRUE Enables OCES diagnostics to be used in combination with TLE. When set to TRUE, all TLE diagnostics are also processed by the OCES logic.
FALSE Disables combined OCES/TLE diagnostics.
If the value of the EnableSetCostProfile field is equal to 0, the EnableCostProfileTLE field is set to FALSE.

Default

FALSE

Changes Take Effect

For new sessions after the DBS Control Record has been written.

Related Information

For More Information on… See…
the EnableSetCostProfile field EnableSetCostProfile.