CANCEL OPTIMIZE Command | Specifying Data Temperatures | Teradata Vantage - CANCEL OPTIMIZE - Analytics Database - Teradata Vantage

Teradata Vantage™ - Teradata® Virtual Storage - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
ulv1628112427040.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hkz1472253437334
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