This section summarizes the benefits, best uses, and restrictions of temperature-based block-level compression in Vantage.
Benefits of Temperature-Based Block-Level Compression
- Can specify for all user data tables, or can apply at the level of individual tables
When applied to an individual table, impacts all compressible subtables and structures associated with that table.
When applied at the level of individual tables, specified compression is inherited by all of the compressible subtables associated with that table, including the following:- Primary data tables
- Fallback data tables
- Index fallback subtables
- CLOB subtables
- Can use query bands and automatic compression to manage the compression status of tables under the control of temperature-based block-level compression
- Can use query bands to load temperature-sensitive tables in either compressed or uncompressed format if you want a uniform compression state and you know the expected temperature of the data being loaded
For more information about using query bands with block-level compression, see BlockCompression Reserved Storage Management Query Bands .
- Has no effect on table header size
Best Use of Temperature-Based Block-Level Compression
- Large tables where a WARM or HOT subset of their data is accessed frequently
- Tables whose temperature profile is relatively stable across time
- Large row-partitioned tables whose activity is concentrated in WARM or HOT row partitions, but whose older row partitions are relatively dormant and COLD
- Column-partitioned tables because their frequently accessed data is grouped together in columnar partitions that are WARM or HOT and other column partitions that are relatively dormant and COLD
Restrictions and Limitations of Temperature-Based Block-Level Compression
- Temperature-based block-level compression applies only to cylinders containing permanent tables.
- After being compressed, data can have a warmer temperature, because after compression and cylinder consolidation, each cylinder contains more data.