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

Purpose

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

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.