Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between " COMPRESS FOR ALL OPERATIONS" and "COMPRESS FOR OLTP"?

759514Mar 11 2010 — edited Aug 5 2010

I was looking through Oracle's OLTP Table Compression (11g onwards) documentation as well as online resources to find the syntax and came across two different versions:

COMPRESS FOR ALL OPERATIONS

and

COMPRESS FOR OLTP

The documentation I looked through didn't mention any alternative syntax, so i was wondering if anyone here might know the difference.

Thank you!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2010

Added on Mar 11 2010

#advanced-compression, #data-warehousing

3 comments

13,278 views