Lets try it !


This page demonstrates compression of data in the second fact table.

Operation


  1. Create and compress the fact table 'subscriber_dedicated_account_usage_compress'.
  2. Create and compress the index on the table
  3. Perform a reorg on the table and index to reorganize the data


Best Practices


  1. 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
  2. Enable compression on tables with huge volumes of data like the fact tables. Small dimension tables do not require compression.