16.10 - About Installing Cost Segments at a Particular Emulation Level - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The following diagnostic request installs the cost segment and activates targ-sys-name_Profile at the specified emulation level.

 DIAGNOSTIC SET COSTS targ-sys-name,
      PROFILE targ-sys-name_Profile ON FOR level;

where level is one of the following scopes.

This scope level … Applies to the current …
REQUEST SQL request.
IFP parsing engine.
SESSION session.
SYSTEM system, meaning there is no restriction enforced.