Solution : https://service.sap.com/sap/support/notes/332677 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues with database index fragmentation, which occupies excessive space. Three primary methods of index defragmentation are discussed: REBUILD, COALESCE, and DROP/CREATE. The REBUILD method, involving a completely new index segment creation, provides optimal defragmentation and allows for parallel processing and storage parameter modifications. COALESCE adjusts leaf blocks under branch blocks without additional space requirements, delivering faster results but no root and branch block defragmentation. DROP/CREATE is advised against due to its high risks and downtime. Implementation specifics, including commands and options for parallel processing and online rebuilding, are provided.
Key words :
rebuild [online] [nologging][parallel <degree>] [compute statistics][rebuild partition, restructure individual index partitions, drop / create mechanism drop, branch blocks remains unchanged, compute statistics, parallel execution slaves, unnecessarily large amount, branch block area, duplicate key records, parallel processing based
Related Notes :
| 1597364 | FAQ: BW-BCT: Extraction performance in source system |
| 1485841 | ALTER INDEX REBUILD does not backup old index statistics |
| 1360603 | Reorganizing and rebuilding individual partitions |
| 1080376 | Enhancements for reorganization and rebuild |
| 979054 | RSORAISQN |
| 852189 | Poor Performance of Mobile Infrastructure under Oracle |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 771929 | FAQ: Index fragmentation |
| 706478 | Preventing Basis tables from increasing considerably |
| 682926 | Composite SAP note: Problems with "create/rebuild index" |
| 651060 | FAQ: Oracle Parallel Execution |
| 618868 | FAQ: Oracle performance |
| 541538 | FAQ: Reorganization |
| 459199 | Measures during the Euro currency conversion |
| 435125 | Poor performance of tables used by CRM (Oracle only) |
| 369123 | ORA-600 [6050] or ORA-600 [25012] |
| 147139 | Build.summarization levels CO-PA is slow/terminates |