SAP Knowledge Base Article - Preview

3490884 - How to confirm whether table auto merge and compression is enabled

Symptom

After deleting entries from a table, table size is not reduced, even grow bigger. At this time it is possible to reduce the table size at once as explained in KBA:
3028886 - Table size on disk does not decrease after data archiving 

You can also wait until auto merge and compression to be finished. However we need to know if the table is enabled to perform auto merge and compression.
Otherwise the table will not be triggered to merge and compression automatically so the table size will not be reduced.


Read more...

Environment

SAP HANA DB

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.