DIAGNOSTIC COSTPRINT
Purpose
Displays optimizer costing information from SystemFE.Opt_Cost_Table.
Syntax
where:
|
Syntax element … |
Specifies … |
|
NOT |
to terminate DIAGNOSTIC COSTPRINT for a request, session, or the current parsing engine. |
|
REQUEST |
that DIAGNOSTIC COSTPRINT is enabled for the next request submitted by the current user. |
|
SESSION |
that DIAGNOSTIC COSTPRINT is enabled for the current session for the current user. |
|
IFP |
that DIAGNOSTIC COSTPRINT is enabled for the current parsing engine for the current user. |
ANSI Compliance
DIAGNOSTIC COSTPRINT is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have SELECT privileges on SystemFE.Opt_Cost_Table to dump cost information to the DBS I/O window using DIAGNOSTIC COSTPRINT.
Valid Scope Levels for DIAGNOSTIC COSTPRINT
DIAGNOSTIC COSTPRINT does not offer a scope level of SYSTEM.