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!
A cynical person might suggest the key difference between is that COMPRESS FOR ALL OPERATIONS is part of the regular Oracle Enterprise Edition database whereas COMPRESS FOR OLTP is part of the Advanced Compression Option (pdf) and so is a chargeable extra to the EE license.
From a features point of view, COMPRESS FOR ALL OPERATIONS is distinguished from COMPRESS FOR DIRECT_LOAD OPERATIONS; that is, it is applied to all DML statements not just bulk inserts. The advantage of COMPRESS FOR OLTP is that (according to the white paper) it has been highly tuned to have a minimal impact on DML statements, which makes it more suitable for OLTP applications. So it is a performance enhancement rather than additional functionality.