Setting or Resetting Cost Parameters

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K
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)
  1. Click . The View Execution Plans dialog box appears.
    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.

    View Execution Plan(s) Expanded - Cost Parameters

  3. Select the Cost tag from the combination box.
    To set the Cost tag at system level, invoke TSET and use the Set TLE feature.