DIAGNOSTIC HELP COSTS - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

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

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

None.

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.

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

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

See “Example 1: DIAGNOSTIC HELP PROFILE Without Options” on page 607 for a continuation of this example to see what DIAGNOSTIC HELP PROFILE reports after you set the profile gonzo on at the session level.

For more information about environmental costs, see:

  • “DIAGNOSTIC DUMP COSTS” on page 596
  • “DIAGNOSTIC SET COSTS” on page 600
  • SQL Request and Transaction Processing