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

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;