PRIORITY - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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