Solution : https://service.sap.com/sap/support/notes/1464156 (SAP Service marketplace login required)
Summary :
As of patch 3, BRSPACE 7.20 now supports index compression for Oracle 10g and 11g. This feature facilitates substantial memory savings for indexes, although it is not suitable for all, such as small indexes or those with varying key field values. Choosing which index columns to compress is crucial for optimal results. Index compression can be toggled in BRSPACE using the "idrebuild" or "tbreorg" options with specified methods to evaluate which indexes should be compressed. Syntax for compression actions and methods are detailed, providing flexibility in implementation. Additional guidelines cover limitations and special conditions for compression applicability to different index types.
Key words :
indexes dtab - decompress tables dlob - decompress lobs dind - decompress indexes dtablob - decompress tables, action ctab - compress tables clob - compress lobs cind - compress indexes ctablob - compress tables, action cind - compress indexes dind - decompress indexes cind_only - compress qualified indexes, ora_proc - oracle provided procedure sap_proc - sap provided procedure val_cmd - results, indexes ctab_only - compress uncompressed tables, eligible index columns <number> - fix number, dind_only - decompress qualified indexes onlydefault, lobs ctabind - compress tables, lobs dtabind - decompress tables, dtablobind_only] table/lob/index compression action
Related Notes :
| 1431296 | LOB conversion and table compression with BRSPACE 7.20 |
| 1428529 | Corrections in BR*Tools Version 7.20 |
| 1289494 | FAQ: Oracle compression |
| 1109743 | Use of Index Key Compression for Oracle Databases |