Allows automatic use of Fast Column Add (FCA) to add new columns to populated user tables without using USING FAST MODE ON in ALTER TABLE syntax. FastAlterDefault should be used carefully because once it is set to TRUE, every alter table that adds columns will switch to fast mode. Before setting FastAlterDefault to TRUE, FastAlterEnable must be set to TRUE.
|TRUE||Enables adding columns to populated user tables in fast mode.|
|FALSE||Default. Use slow mode to add columns.|
Changes Take Effect
After the DBS Control Record has been written.
- Use this DBS control flag to add new columns with non-null default values to tables with large number of rows, which would normally take a lot of time to complete.
- Does not add value for smaller tables that typically take little time to add new columns.
- Teradata Vantage™ - SQL Data Definition Language Syntax and Examples