cancel
Showing results for 
Search instead for 
Did you mean: 

What is the recommended number of partitions for the table  /1CPMB/XXYY?

SAPSupport
Employee
Employee
0 Kudos
815


Hi,

The record count of the table /1CPMB/DXSYWAD has exceeded 1.5billion in system .

Table partitioning is necessary if a NON-BW table is about to exceed the maximum of 1908053839 records because of the System Limitations.

Please confirm what is the recommended number of partitions to request & column name for the table /1CPMB/XXYY to request for partition ?

Thanks


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee
0 Kudos

From BPC application perspective, there is no recommended number of partitions. Please just consider it from your DB performance perspective.

As long as your partition works fine, there is not issue for BPC.

Refer to the attached KB 2516035 - "BPC model with more than 2 billion records - BPC NW /HANA".

If you any further question regarding HANA DB, please create a incident to the component HAN-DB.

Answers (0)