Skip to Content

sap hana table size is not decreasing.

Apr 11 at 07:33 AM


avatar image

Hi All,

I have setup housekeeping jobs in the systems due to which one of the table entries deleted more than 50% but table size is not decreased.

The database is SAP HANA 1.0 SPS12

The table names are for e.g. RSECLOG, BALDAT, DBTABLOG etc.

Please suggest if we need to perform any DB related action or is it normal as per SAP HANA architecture ?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Martin Winn Apr 11 at 09:08 AM

Can you check if a delta merge took place after deletion?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your response.

The entries are deleted few days back. Delta merge must have taken place. However I will confirm the same ASAP.

Basis Team Applied

Last delta merge is in 2017. I have executed delta merge manually for a table and I still see the size is not decreased.