Use Teradata Visual Explain to set or reset cost parameters for the session.
Refer to the following publications for more information on emulating cost parameters:
- Teradata System Emulation Tool User Guide (B035-2492)
- SQL Request and Transaction Processing (B035-1142) (Target Level Emulation)
The View Execution Plans dialog box appears.View Execution Plans - Cost Parameters
Click More to show QCD Options and Emulation parameters.
The Cost Parameter is set at session level, which is reset after submitting the request.View Execution Plan(s) Expanded - Cost Parameters
Select the Cost tag from the combination box.
To set the Cost tag at system level, invoke TSET and use the Set TLE feature.