16.10 - EnableCostProfileTLE - 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

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. For additional information, see EnableSetCostProfile.

Default

FALSE

Changes Take Effect

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

Example: Using the EnableCostProfileTLE field of DBS Control

When EnableCostProfileTLE is set to FALSE, the following syntax for the DIAGNOSTIC SET COSTS statement is valid.



When EnableCostProfileTLE is set to TRUE, the following syntax for the DIAGNOSTIC SET COSTS statement is valid.



Related Topics

For More Information on… See…
DIAGNOSTIC SET COSTS statement SQL Data Manipulation Language.
using TLE and OCES diagnostics SQL Request and Transaction Processing.