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

Teradata Vantage™ - Teradata® Virtual Storage

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

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

Related Information