Setting or Resetting Cost Parameters - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 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 46: 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).