Types of Hybrid Columnar Compression

If your underlying storage supports Hybrid Columnar Compression, then you can specify different types of compression, depending on your requirements.

ai and machine learning training courses malaysia

The compression options are:

• Warehouse compressionThis type of compression is optimized to save storage space, and is intended for data warehouse applications.
• Archive compressionThis type of compression is optimized for maximum compression levels, and is intended for historical data and data that does not change.

red hat certified system administrator rhcsa malaysia

Hybrid Columnar Compression is optimized for data warehousing and decision support applications on Oracle Exadata storage. Oracle Exadata maximizes the performance of queries on tables that are compressed using Hybrid Columnar Compression, taking advantage of the processing power, memory, and Infiniband network bandwidth that are integral to the Oracle Exadata storage server.

agile project management certification training courses malaysia

Other Oracle storage systems support Hybrid Columnar Compression, and deliver the same space savings as on Oracle Exadata storage, but do not deliver the same level of query performance. For these storage systems, Hybrid Columnar Compression is ideal for in-database archiving of older data that is infrequently accessed.

microsoft windows server certification training courses malaysia