15.00 - EnableCostProfileTLE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

EnableCostProfileTLE

Purpose  

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

Note: This setting 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.

Note: If the value of the EnableSetCostProfile field is equal to 0, the EnableCostProfileTLE field is set to FALSE. For additional information, see “EnableSetCostProfile” on page 327.

Default

FALSE

Changes Take Effect

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

Example  

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.