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).
My concern is will partitioning the table result in any performance deterioration?
Or can anyone suggest a better mechanism to do the same.