• 1 reply
  • Latest Post - ‏2012-10-08T08:31:53Z by SystemAdmin
31 Posts

Pinned topic Database Reorgs

‏2012-10-04T17:51:05Z |
What is best practice for running Reorg jobs on the TADz database? We are planning to do Reorgs monthly. We have not yet started running the utilities to delete data but plan to do those monthly. We are 7.5. We load usage data weekly and discovery monthly.

Is there a particular set of tables we should concentrate on for Reorgs?

Pat Cole
Updated on 2012-10-08T08:31:53Z at 2012-10-08T08:31:53Z by SystemAdmin
  • SystemAdmin
    47 Posts

    Re: Database Reorgs

    Hi Pat,

    When you run reorgs you tend to do these on the Repository as a whole since you will be updating most of these tables on a regular basis. I would say that running reorgs on a monthly basis should be enough. Other sites I know about will run these after they do their weekly Usage Imports but it's really a site decision.

    Jim K.