The following table describes the flushing options for this statement.
| Option | Cache Set Flushed | Table Set Updated |
|---|---|---|
| ALL | All ALLDBQL and all ALLTDWM caches |
|
| ALLDBQL | All DBQL caches |
|
| ALLTDWM | All TDWM caches |
|
| AMPDATA | DBQL AMP Data Table cache Also flushes DBQL Default Table cache to prevent orphaned rows. |
|
| 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 |
| USECOUNT | ObjectUsage cache | DBC.ObjectUsage |
| XMLPLAN | XML Table | DBQLXMLTbl |