37 / 577
37
PUBLIC
© 2017 SAP SE or an SAP affiliate company. All rights reserved. ǀ
SAP HANA Technology
Other compression operations
Compression rate depends on data distribution
Decompression is not necessarily required for all operations:
i.e. max or avg
Direct update into compressed storage is expensive
:
So Split into delta and main storage with periodic merges
Take Aways:
A B C D E F G H I J K L M N O P 5 4 3 4 2 2 2 4 4 4 5 5 4 3 3 2
A K L B D H I J M C N O E F G P 5 5 5 4 4 4 4 4 4 3 3 3 2 2 2 2
Sort