17.00 - flush_option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Specifies which database query logging or Teradata workload management cache to flush:
  • ALL
  • ALLDBQL
  • ALLTDWM
  • DEFAULT
  • EXPLAIN
  • LOCK
  • OBJECTS
  • PARAMINFO
  • SQL
  • STATUSAGE
  • STEPINFO
  • SUMMARY
  • TDWMEVENT
  • TDWMEXCEPTION
  • TDWMHISTORY
  • USECOUNT
  • XMLPLAN

ALL is mutually exclusive to all other options.

ALLDBQL is mutually exclusive to all other DBQL options.

ALLTDWM is mutually exclusive to all other TDWM options.

For more information, see “FLUSH QUERY LOGGING” in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184