DIAGNOSTIC HELP COSTS - Teradata Database

Purpose

Reports information about the workload cost estimates and Target Level Emulation (TLE) cost segments.

Required Privileges

None.

Syntax

ANSI Compliance

DIAGNOSTIC HELP COSTS is a Teradata extension to the ANSI SQL:2011 standard.

Target Level Emulation and DIAGNOSTIC HELP COSTS

DIAGNOSTIC HELP COSTS does not require Target Level Emulation to be enabled, but it cannot report scope-level cost estimation data unless TLE is enabled.

Session Mode Restrictions

You cannot perform DIAGNOSTIC HELP COSTS in ANSI session mode or within explicit transaction boundaries in Teradata session mode.

Example: Report Active Cost Profile and TLE Cost Segment Information

DIAGNOSTIC HELP COSTS reports information about the active cost profiles and TLE cost segments. For example, assume you have performed the following request:

     DIAGNOSTIC SET PROFILE gonzo ON FOR SESSION;

If you then execute a DIAGNOSTIC HELP COSTS request, the system produces the following report:

     DIAGNOSTIC HELP COSTS;

      *** Help information returned. 4 rows.
      *** Total elapsed time was 1 second.
     Status of Cost Profile and TLE Cost Parameters
     --------------------------------------------------------
     REQUEST: gonzo [Id = 10003, Type = 2]
     SESSION: gonzo [Id = 10003, Type = 2] TLE IS IFP
     IFP    : T2_Linux64 [Id =    21, Type = 2] TLE IS SYSTEM
     SYSTEM : T2_Linux64 [Id =    21, Type = 2] TLE IS TPA

For a continuation of this example to see what DIAGNOSTIC HELP PROFILE reports after you set the profile gonzo on at the session level, see Example: DIAGNOSTIC HELP PROFILE Without Options.