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. |