SAP Knowledge Base Article - Preview

3757323 - Finding the RANGE value information of records located in the OTHERs partition of a HANA table

Symptom

  • The OTHERS partition on a RANGE partitioned HANA table is being consumed and growing near the 2 billion record threshold limit.
  • In this example, the EDID4 table already has 12 ranges existing based on the DOCNUM column with 1.9 billion records outside of the '0000000000000000' -> '0000000044000000' :

    SELECT COUNT(*) FROM EDID4 WHERE DOCNUM NOT BETWEEN '0000000000000000' AND '0000000044000000'

    1919145089

 

  • How to determine new possible RANGE threshold values for existing records and new range partitions to hold them ?

 


Read more...

Environment

SAP HANA Platform Edition 2.0

Product

SAP HANA, platform edition all versions

Keywords

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.