The following tables are approaching 1.5 billion records. Could you please suggest the appropriate table partitioning method for these tables and share the relevant SAP Notes/documentation for reference. attched steps and confirm. table
For tables like EDID4, OBJK, and FAGLFLEXA approaching 1.5 billion records, SAP recommends partitioning them in SAP HANA using either range or hash-based schemes. The most effective approach is to use time-based range partitioning (for tables with date fields) or hash partitioning (for technical/object tables without natural ranges). Each partition should ideally hold no more than ~300 million records to optimize query performance and delta merge operations. Check this SAP Help Creating an Effective Partitioning Scheme Also check SAP note 2044468
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.