There is a big fact table (70 gig) in our database. There are 11 years of data on the table. The table is paritioned at year. If I split the table into two tables, one for archiving data ( about 7 years of data), another one for the new data (about 4 years of data), is it going to improve the query performance? The new data table is usually the query access the most.
How could I find it out?

Thanks!