3 Replies Latest reply: Aug 5, 2010 8:02 AM by 789685 RSS

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

    759514
      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!