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.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
yje1557098840879.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1179
lifecycle
previous
Product Category
Teradata Vantage™

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