Teradata does not recommend enabling Target Level Emulation on a production system.
Purpose
A set of DIAGNOSTIC SQL statements that set cost information.
The Target Level Emulation field allows field test engineers to set the costing parameters considered by the Optimizer for the system.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | Enable this feature. |
| FALSE | Disable this feature. When this field is disabled, the DIAGNOSTIC SET COSTS statement will not be accepted. (An error is reported.) The DIAGNOSTIC DUMP COSTS statement can be executed when the feature is disabled. |
Default
FALSE
Changes Take Effect
After the DBS Control Record has been written.
Related Topics
See “Target Level Emulation” in SQL Request and Transaction Processing.