Avatar

Correct answer by
Community Advisor

Hi Ramaswami,

 

You may need to do a defragmentation of data across the database as it removes bloat from the system which is caused by constant deletes done to the schemas.

In high transactional databases, deletes performed on schemas cause bloat or empty spaces. This bloat continuously grows until a defragmentation is carried out.
Some of the indexes also need to be deleted or recomputed.

 

You can find more details Data model best practices  or Technical maintenance 

 

Basically, you will need a DBA to help with the maintenance, cleanup table, re-index tables etc. 

You can also get in touch with Adobe PS to complete a database usage plus instance audit and let you know what steps to take.

 

Thanks,

David

View solution in original post