17.10 - FastAlterDefault - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
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

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