SAP Knowledge Base Article - Preview

3831241 - Reduce HANA memory usage from table indexes by removing unused secondary indexes.

Symptom

  • Excessive memory consumption by table indexes in the database.
  • Large custom tables reported among top memory consumers.
  • Need to reduce RAM utilization to avoid system performance degradation.


Read more...

Environment

  • SAP S/4HANA Cloud Private Edition
  • SAP HANA Database

Product

SAP HANA, platform edition all versions ; SAP S/4HANA Cloud Private Edition all versions

Keywords

SAP HANA, column store, secondary index, INVERTED INDIVIDUAL, index memory, M_CS_INDEXES, INDEX_COLUMNS, TOTAL_READ_COUNT, LAST_USED_TIME, drop index, memory footprint, RAM utilization, delta merge, optimize compression, largest tables , 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.