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

Teradata® Virtual Storage

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
gsg1592014116145.ditamap
dita:ditavalPath
gsg1592014116145.ditaval
dita:id
B035-1179
lifecycle
previous
Product Category
Teradata Vantage™

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