15.00 - Flushing Options - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Flushing Options

The following table describes the flushing options for this statement.

 

This Option …

Flushes This Cache Set …

And Updates This Table Set …

ALL

All ALLDBQL and all ALLTDWM caches

  • DBQLExplainTbl
  • DBQLObjTbl
  • DBQLogTbl
  • DBQLParamTbl
  • DBQLSqlTbl
  • DBQLStepTbl
  • DBQLSummaryTbl
  • DBQLXMLTbl
  • TDWMEventHistory
  • TDWMEventLog
  • TDWMExceptionLog
  • ALLDBQL

    All DBQL caches

  • DBQLExplainTbl
  • DBQLObjTbl
  • DBQLogTbl
  • DBQLParamTbl
  • DBQLSqlTbl
  • DBQLStepTbl
  • DBQLSummaryTbl
  • DBQLXMLTbl
  • ALLTDWM

    All TDWM caches

  • TDWMEventHistory
  • TDWMEventLog
  • TDWMExceptionLog
  • DEFAULT

    DBQL Default Table cache

    DBQLogTbl

    EXPLAIN

    DBQL Explain Table cache

    DBQLExplainTbl

    LOCK

    DBQL Lock Logger cache

    DBQLXMLLockTbl

    OBJECTS

    DBQL Objects Table cache

    DBQLObjTbl

    PARAMINFO

    DBQL Parameter Table

    DBQLParamTbl

    SQL

    DBQL SQL Table cache

    DBQLSqlTbl

    STEPINFO

    DBQL Step Table cache

    DBQLStepTbl

    SUMMARY

    DBQL Summary Table cache

    DBQLSummaryTbl

    TDWMEVENT

    TDWM Event Log Table cache

    TDWMEventLog

    TDWMEXCEPTION

    TDWM Exception Log Table cache

    TDWMExceptionLog

    TDWMHISTORY

    TDWM Event History Table cache

    TDWMHistory

    XMLPLAN

    XML Table

    DBQLXMLTbl