How we do compression, Partition, Aggregation in HANA ?.

[pavneet_rana]

Hi to all,

How we can achieve the compression and partition in SAP HANA database for table ?.

Also can we do aggregation on table in SAP HANA, if yes then HOW?.

Regards

Pavneet Rana

[vivekbhoj · Accepted solution]

Hi Pavneet,

There is no need for compression and aggregation in HANA as the tables are stored in column store and in already compressed form as it uses Dictionary Encoding

Read more about InMemory Database from OpenHPI:

Course: In-Memory Data Management

For partitioning, read the HANA Admin Guide:

http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf

Regards,

Vivek