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;