If you want to query (management asks for) the yearly turnover of the company from the start of the year to yesterday and you have 1000000+ invoices  ... It is time and resource consuming, even with stored procedures. If I have monthly archives (tables) then I have to query each of the tables.