Adding Columns with USING FAST MODE ON
The following statement adds columns custid and custaddr to existing, populated table sales_hist, converting sales_hist to FCA format if sales_hist is in non-FCA format.
ALTER TABLE sales_hist
USING FAST MODE ON
ADD custid INT DEFAULT 9999,
ADD custaddr VARCHAR(1000);
Adding Columns with USING FAST MODE OFF
The following statement adds columns custid and custaddr to existing, populated table sales_hist, converting sales_hist to non-FCA format if sales_hist 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;