17.10 - Examples: USING FAST MODE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

Adding Columns with USING FAST MODE ON

Adds columns custid and custaddr to existing, populated table sales_hist, converting sales_hist to FCA format if it is in non-FCA format.

If DBSControl parameters FastAlterEnable and FastAlterDefault are enabled (the default), you can omit USING FAST MODE ON.

ALTER TABLE sales_hist 
USING FAST MODE ON
ADD custid INT DEFAULT 9999,
ADD custaddr VARCHAR(1000);

Adding Columns with USING FAST MODE OFF

Adds columns custid and custaddr to existing, populated table sales_hist, converting sales_hist to non-FCA format if it is in FCA format.

ALTER TABLE sales_hist 
USING FAST MODE OFF
ADD custid INT DEFAULT 9999,
ADD custaddr VARCHAR(1000);

Converting Table from FCA Format to Non-FCA Format without Adding Columns

ALTER TABLE sales_hist USING FAST MODE OFF;