Installing Cost Segments at a Particular Emulation Level - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Installing Cost Segments at a Particular Emulation Level

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.