Skip to Content
0
Jul 16, 2018 at 07:31 AM

What is the best way to carry retention on a large table with 1.5bn+ records ? (SAP HANA SP12)

57 Views Last edit Jul 16, 2018 at 07:31 AM 2 rev

We've a table with record count : 1,93,55,48,425.

We want to carry a retention activity on the same : Which keeps only the current month + last 6 months records in the table.

We're thinking of :
Partitioning the table and then dropping the older partitions (older than 6 months).

Concerns:

My concern is will partitioning the table result in any performance deterioration?
Or can anyone suggest a better mechanism to do the same.