Example: Set Cost Profile For System
This request sets the active SYSTEM-level cost profile using constant values from the profile named T2_special:
DIAGNOSTIC SET PROFILE T2_special ON FOR SYSTEM;
Example: Set Cost Profile For Session or Request
This request sets the active SESSION-level or REQUEST-level cost profiles using constant values from the profile named T2_workaround1265:
DIAGNOSTIC SET PROFILE T2_workaround1265 ON FOR SESSION; DIAGNOSTIC SET PROFILE T2_workaround1265 ON FOR REQUEST;
Example: Set Cost Profile For IFP-Level
This request sets the active IFP-level cost profile (an IFP-level scope applies to the current parsing engine only) using constant values from the profile named T2_workaround23:
DIAGNOSTIC SET PROFILE T2_workaround23 ON FOR IFP;
After the system processes this request, Teradata Database uses this IFP-level profile:
- For new sessions.
- As the prior cost profile for a subsequent DIAGNOSTIC SET PROFILE NOT ON FOR SESSION request.
Example: Deactivate Cost Profiles
This request deactivates all cost profiles at the specified scope level:
DIAGNOSTIC SET PROFILE OFF FOR SESSION;