Purpose
Displays optimizer costing information from SystemFE.Opt_Cost_Table.
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.
Syntax
Syntax Elements
- 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.
ANSI Compliance
DIAGNOSTIC COSTPRINT is a Teradata extension to the ANSI SQL:2011 standard.
Valid Scope Levels for DIAGNOSTIC COSTPRINT
DIAGNOSTIC COSTPRINT does not offer a scope level of SYSTEM.