Q
Problem solve Get help with specific problems with your technologies, process and projects.

Exadata, hybrid columnar compression, and inserts

One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata.

I have a question related to Exadata. Why are the new rows that are inserted into the compressed table not getting compressed? It is it like I need to compress it again.

Exadata Hybrid Columnar Compression only does compressions on direct load operations, so rows added with INSERT operations will not be compressed.

Dig Deeper on Oracle database performance problems and tuning

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close