16.20 - CANCEL OPTIMIZE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Teradata® Virtual Storage

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Configuration
Publication ID
B035-1179-162K
Language
English (United States)
Last Update
2019-05-02

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



Example: CANCEL OPTIMIZE

Ferret  ==>
> cancel optimize

Optimization has been stopped on all vprocs