Should I split tables by year?

Hi,

I am starting from scratch my dataset and have a common structure of:

• Order lines
• Delivery note lines
• Invoice line

since many years ago.

I was wondering if it makes sense to split those tables in two each, with current year on one table, and past years on another, so my refresh process would take much less data and time every day, as far as old data should never be updated.

On the other side, as order headers, delivery note headers and invoice headers are much smaller, I would keep one for each, for the whole years.

Daoes it make sense?

Thanks,