3627890 - Slow performing Delta Merge on a table with a low record count but a large memory size in SAP HANA

• A table in HANA reports a long delta merge runtime + a large size in main memory. Mini checks reports the symptoms :
  

  |M0525|Tables / partitions with large memory size      |             |ESH_FL_FTASK (175 GB)                                      |none          |X| 2044468|
  |M0537|Tables with long total merge time (short-term)  |             |ESH_FL_FTASK (4.17 h)                                      |none          |X| 2057046|
  |M0538|Long running delta merges (mid-term)            |             |ESH_FL_FTASK (11925 s, 2025/06/13 23:57:52)                |none          |X| 2057046|

• 'HANA_Indexes_Overview.txt' shows the index type and it's size
  

  -------------------------------------------------------------------------------------------------------------------------------------------------------------------
  |SCHEMA_NAME|TABLE_NAME                                   |S|P|INDEX_NAME                                |C|INDEX_TYPE|COLS|INDEXES|MEM_SIZE_GB|INV_HASH_SAVING_GB|
  -------------------------------------------------------------------------------------------------------------------------------------------------------------------
  |SAPERP     |ESH_FL_FTASK                                 |C| |_SYS_FSI_#ESH_FL_FTASK~FSP                | |FULLTEXT  |   1|      1|     177.24|              0.00|

• 'HANA_Indexes_TextIndexes_Overview.txt' shows further details in the context of Fulltext indexes for ESH tables using Fuzzy search :
  
  

  [DESCRIPTION]
  
  - Overview of fulltext indexes
  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  |SCHEMA_NAME|TABLE_NAME                                   |INDEX_NAME                                  |EXP|FPR|FUZ|SEO|TAN|TMI|PIR  |COLUMN_NAME                   |SIZE_MB   |SEPARATORS                  |COUNT|
  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  |SAPHANADB  |ESH_SR_LTXT                                  |_SYS_FSI_#ESH_SR_LTXT~FS1                   |   |X  |X  |   |   |   | 0.20|$_SYS_SHADOW_LONGTEXT$        |  57104.98|\/;,.:-_()[]<>!?*@+{}="&#$~||    1|
  |SAPHANADB  |ESH:QS1216~QS1216~ESH_SAPSCRIPT_TEXT~LONGTEXT|esh:ftx~qs1216~a2363004ad19~longtext        |X  |X  |X  |   |   |   | 0.00|$_SYS_SHADOW_LONGTEXT$        |  22999.05|\/;,.:-_()[]<>!?*@+{}="&#$~||    1|
  |SAPHANADB  |ESH:QS1211~QS1211~ESH_SAPSCRIPT_TEXT~LONGTEXT|esh:ftx~qs1211~617d8d812398~longtext        |X  |X  |X  |   |   |   | 0.00|$_SYS_SHADOW_LONGTEXT$        |  10420.13|\/;,.:-_()[]<>!?*@+{}="&#$~||    1|

SAP HANA Platform Edition 2.0

ESH_FL_FTASK, partitions with large memory size, Tables with long total merge time (short-term), Long running delta merges (mid-term)