Re: Quick Question as I can't find the answer (Advanced Compression)

From: Oleksandr Denysenko <>
Date: Tue, 15 May 2018 17:27:36 +0300
Message-ID: <>


use one of (to not trigger ACO usage):

  1. move without ONLINE option - quite good for historical data
  2. create new table with the same structure and compression enabled using CTAS

    create the same indexes. troubles with GLOBAL....


I prefer 2) because during this operation you may do RIGHT ORDER BY to place repeating values closer and increase compression ratio or increase indexes clustering factor.

Best Regards,

     Oleksandr Denysenko

15.05.2018 16:48, Chris Taylor пишет:
> If we (DBAs) want to specify compression on a Partition/Subpartition, which options are specific
> to Advanced Compression and which are not?
> For example, this link says:
> " Certain uses of
> Online Move Partition require Advanced Compression: specifically, if the
> feature is used to move a partition or subpartition to a compressed format
> including Basic, Advanced Row, or Hybrid Columnar Compression."
> I'm trying to find a simple answer on how to get compression and avoid advanced compression
> gotchas as we're not licensed to use it.
> Chris

Received on Tue May 15 2018 - 16:27:36 CEST

Original text of this message