欢迎投稿

今日深度:

Purge Data,

Purge Data,


Purge Data

From IBM Knowledge Center

Purging is a process of moving records from the base or main database table to the history table. The base table is also referred as the key transactional table that is archived.
Data, if not purged results in the increase of database size that can negatively impact the database operations and affect the overall system performance. The performance impact can be observed by the delayed response in a UI, increased database backup time, and so on. As managing data is key to protecting the business, purging records periodically is highly beneficial in reducing the database bloat with marked improvement on the system performance.
The purge process involves:

  • Moving the relevant data from the base table to the history table by using the business rules specified for purge.
  • Deleting purged rows from the base table once they have been successfully transferred to the history table.

www.htsjk.Com true http://www.htsjk.com/teradata/31468.html NewsArticle Purge Data, Purge Data From IBM Knowledge Center Purging is a process of moving records from the base or main database table to the history table. The base table is also referred as the key transactional table that is archived. Data, if n...
相关文章
    暂无相关文章
评论暂时关闭