Truncates old history rows from TDMaps tables. Periodically run this procedure to prevent historical data from consuming an excessive amount of space.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
CALL [TDMaps.] TruncateHistorySP ('OlderThan', :NumDeletedRows) [;]
Syntax Elements
- TDMaps.
- The name of the database.
- OlderThan
- Deletes TDMaps history data older than the specified time. It cannot be NULL.
- NumDeletedRows
- The output parameter for the number of deleted rows in ActionHistoryTbl, LogTbl, and AnalyzeLogTbl.