17.10 - PRIORITY - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The PRIORITY command allows you to set the priority of the Ferret process.

The PRIORITY command is most commonly used with the SCANDISK and PACKDISK commands.

Syntax

[ SET ] PRIORITY = priorityclass

Syntax Elements

priorityclass
The priority of the Ferret process.
Valid values for priorityclass are:
  • LOW, L, or 0
  • MEDIUM, M, or 1 (This is the default.)
  • HIGH, H, or 2
  • RUSH, R, or 3
These values are not case sensitive.

Example: Setting the priority of Ferret

An example is shown below:

Ferret ==>
SET PRIORITY = 3