Setting or Resetting Cost Parameters
Use Teradata Visual Explain to set or reset cost parameters for the session.
To set or reset cost parameters
1 Click .
The View Execution Plans dialog box appears.
Figure 45: View Execution Plans - Cost Parameters2 Click More >> to show QCD Options and Emulation parameters. The Cost Parameter is set at session level, which is reset after submitting the request.
Figure 46: View Execution Plan(s) Expanded - Cost Parameters3 Select the Cost tag from the combination box.
Note: To set the Cost tag at system level, invoke TSET and use the Set TLE feature.
Refer to the following publications for more information on emulating cost parameters: