Example: BEGIN 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™
Ferret  ==>
> begin optimize

BEGIN OPTIMIZE command could consume significant system resources
        Do you wish to continue?? (Y/N)
> Y
Optimization has been started on all vprocs

If you wish to revert this optimization to a low level background mode, you can issue a CANCEL OPTIMIZE command