One other alternative - create an archive table on the partition scheme, switch the old data out of the current table into the archive table. This will serve two purposes:
> keep the running table moderatly small
> retain the history for a given period of time
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”