Maintain Data Dictionary Tables | VantageCloud Lake - Maintaining Data Dictionary Tables - Teradata VantageCloud Lake

Managing the size of Data Dictionary tables (sometimes called logs) can help improve performance. Database Engine 20 does not delete system data on its own, so you must manage the logs and tables yourself. Determine what to archive and what to delete, as needed, for your site. Use one of the methods mentioned in Method for Maintaining Database Logs.

• Clearing the System Logs
• Clearing Values Manually in the DBC.Acctg Table
• Archiving and Resetting Accumulators and Peak Values
• Collecting Statistics on Data Dictionary Tables
• Data Dictionary Tables that Require Maintenance