DIAGNOSTIC COSTPRINT - 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

Displays optimizer costing information from SystemFE.Opt_Cost_Table.

where:

 

Syntax element …

Specifies …

NOT

Terminate DIAGNOSTIC COSTPRINT for a request, session, or the current parsing engine.

REQUEST

DIAGNOSTIC COSTPRINT is enabled for the next request submitted by the current user.

SESSION

DIAGNOSTIC COSTPRINT is enabled for the current session for the current user.

IFP

DIAGNOSTIC COSTPRINT is enabled for the current parsing engine for the current user.

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

You must have SELECT privileges on SystemFE.Opt_Cost_Table to dump cost information to the DBS I/O window using DIAGNOSTIC COSTPRINT.

DIAGNOSTIC COSTPRINT does not offer a scope level of SYSTEM.

  • “DIAGNOSTIC DUMP COSTS” on page 596
  • “DIAGNOSTIC HELP COSTS” on page 598
  • “DIAGNOSTIC SET COSTS” on page 600