Setting or Resetting Cost Parameters - Visual Explain

Use Teradata Visual Explain to set or reset cost parameters for the session.

1 Click .

The View Execution Plans dialog box appears.

Figure 44: View Execution Plans - Cost Parameters

2 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 45: View Execution Plan(s) Expanded - Cost Parameters

3 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:

Teradata System Emulation Tool User Guide B035-2492.

SQL Request and Transaction Processing B035-1142 (Target Level Emulation).