Answer

Exadata, hybrid columnar compression, and inserts

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.

    Requires Free Membership to View

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

This was first published in May 2011

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: