Compression in a relational database allows more efficiently storage of data, reduced
memory consumption, and improve performance due to lower I/O demands.
Index compression supports:
- Index leaf page compression
- Both DOL and APL index leaf page formats
- Compression at the table, index, and local index partition levels