17.10 - FastAlterDefault - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

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


Valid Settings

Setting Description
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.

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