Any recommended way to periodically purge "old" data from a table?
We have tables that store information based on time, for example alarms. This information is required to be stored for a certain time period and then removed. The insertion rate could be very high and running a "delete from where time ...." will affect performance. For these cases what is the recommended approach?
0