Lets try it !
This page demonstrates compression of data in the second fact table.
Operation
- Create and compress the fact table 'subscriber_dedicated_account_usage_compress'.
- Create and compress the index on the table
- Perform a reorg on the table and index to reorganize the data
Best Practices
- If you are running a multi-terabyte database and using a little more CPU is not a concern, then compression is a very good option to consider
- Enable compression on tables with huge volumes of data like the fact tables. Small dimension tables do not require compression.