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