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.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | Enables adding columns to populated user tables in fast mode. |
| FALSE | Default. Use slow mode to add columns. |
Default
FALSE
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
- 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.
Related Information
- FastAlterEnable
- Teradata Vantage™ - SQL Data Definition Language Syntax and Examples