- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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