15.00 - Target Level Emulation - 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

Target Level Emulation

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