Ah - I missed that part about it being specific to ONLINE operations.
On Tue, May 15, 2018 at 9:27 AM, Oleksandr Denysenko <odenysenko@xxxxxxxxx>
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
create the same indexes. troubles with GLOBAL....
do EXCHANGE PARTITION
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.
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.