What is the purpose of Reorganisation? Thanks
Reorgs are usually done on the table spaces. Mostly we do reogrs to optimize and recapture space. Also if you're extracting data from these tables to some other systems, files, etc, it helps the extract process. You need to look at the size of the tables, the rate of growth and then plan the reorgs accordingly, yearly, half yearly, quarterly, once every 2 months, etc depending on your requirements and growth.