15.00 - EnableSetCostProfile - 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

EnableSetCostProfile

Purpose  

Controls usage of DIAGNOSTIC SET PROFILE statements to dynamically change cost profiles, which are used for query planning.

Note: This setting should be changed only under the direction of Teradata Support Center personnel.

Field Group

General

Valid Settings

 

Setting

Description

0

Disable DIAGNOSTIC SET PROFILE statements.

1

Enable DIAGNOSTIC SET PROFILE statements for SESSION and REQUEST levels.

2

enables DIAGNOSTIC SET PROFILE statements at all levels.

Default

0

Changes Take Effect

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

Related Topics

 

For more information on…

See…

using the DIAGNOSTIC SET PROFILE statement

SQL Data Manipulation Language.

cost profiles

SQL Request and Transaction Processing.