sap hana table size is not decreasing.

[former_member234716]

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 ?

Thanks,

Prabhakar.

[former_member233657]

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

[former_member234716]

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.

[former_member234716]

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