Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is data compression all automatic? Or does manual steps occur in HANA Studio

Hi all,

I'm new to HANA and have been leveraging SCN in a BIG way to answer my questions (thanks everyone for your contributions). This is my first post as I was unable to find an answer to my current question .

I've been reading up on data compression in HANA and I learned that there are different techniques, such as Dictionary, Cluster, and Run-length encoding.

My Question is: Is the compression automatic? Or does it need to be modeled within HANA Studio? Let's use Dictionary Encoding as an example. Are there algorithms in place within HANA that will automatically aggregate values so only distinct values remain? Will the attribute vector  and inverted indexed tables automatically be created?

Just as some background, this is what I am basing my question on:

http://www.agilityworks.co.uk/our-blog/demystifying-the-column-store-%E2%80%93-viewing-column-store-statistics-in-sap-ha…

Thank you!

Kyle

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question