Browse
Community
Teradata.com
Teradata Support
Register
·
Sign In
·
Help
suggest ways to clean up DBC.
Database
All community
This category
This board
Knowledge base
Users
turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
rahamanatikur
Not applicable
Mark as New
Bookmark
Subscribe
Subscribe to RSS Feed
Get Direct Link
Print
Email to a Friend
Report Inappropriate Content
05-07-2009
10:29 AM
05-07-2009
10:29 AM
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.
All forum topics
Previous Topic
Next Topic
1 REPLY
robpaller
Enthusiast
Mark as New
Bookmark
Subscribe
Subscribe to RSS Feed
Get Direct Link
Print
Email to a Friend
Report Inappropriate Content
05-14-2009
08:24 PM
05-14-2009
08:24 PM
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.