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.