Skip to Content
avatar image
Former Member

sap hana table size is not decreasing.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 11 at 09:08 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

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