FastAlterDefault - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
vkz1472241255652
Product Category
Software
Teradata Vantage

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