17.10 - FOR CURRENT Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

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

If you specify the FOR CURRENT option in a USING clause, Vantage applies that USING clause only for the current collection of statistics.

If you do not specify FOR CURRENT, then Vantage applies the USING clause to the current statistics collection and all subsequent collections of statistics on the specified column set.