Case : I want to reorganize table and rebuild index offline for table SOFFCONT1. Table SOFFCONT1 contains SAP Business Workplace/SAPoffice objects which often grow rapidly in Netweaver based component.
Procedure : Here’s the procedure to export/import tables and rebuild index using BRTOOLS,
- Export table SOFFCONT1
- Drop index
- Import table SOFFCONT1
- Run Update Statistics Optimizer
Details steps : Continue reading