CANCEL OPTIMIZE Command | Specifying Data Temperatures | Teradata Vantage - 17.00 - 17.05 - CANCEL OPTIMIZE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Teradata® Virtual Storage

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Configuration
Publication ID
B035-1179-170K
Language
English (United States)

Purpose

Halts the high-priority optimization data migration that was begun by the BEGIN OPTIMIZE command. Migration for the process of data storage optimization reverts to the normal lower-priority background process. The normal background migration process imposes a minimal workload on system resources.

Syntax

CANCEL { OPTIMIZE | OPT }

Example: CANCEL OPTIMIZE

Ferret  ==>
> cancel optimize

Optimization has been stopped on all vprocs