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