suggest ways to clean up DBC.

Database

suggest ways to clean up DBC.

Cleaning up the DBC tables are sufficient or do we need to clean up the views also.
please provide the list of tables and views that we need to clean up.
any help is highly appreciated.
1 REPLY

Re: suggest ways to clean up DBC.

The DBQL, resusage, and accesslog tables can be purged (or data relocated to another database) to satisfy your retention periods.

It is also a best practice to use roles to keep the number of rows in the AccessRights table to a minimum.