DIAGNOSTIC HELP COSTS
Purpose
Reports information about the workload cost estimates and Target Level Emulation (TLE) cost segments.
Syntax
ANSI Compliance
DIAGNOSTIC HELP COSTS is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
None.
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
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 626 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
For more information about environmental costs, see: