Hi,

It all depends on your system. Difficult to say if you should do it by date, id or something else.

The last time I partioned a table I had two parts an historic part and one current, which was partioned by a integer flag that stated if it was a historic part or current.

Best regards,

Shakir