16.10 - Target Level Emulation - 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
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.