Hi I have a question regardig big databases. I have worked with mine since 2008 and there is a lots of data stored and that ofcourse takes time to handle. I want to devide this tables in two. One part that just include the last three years and one for the rest. 99% of the time You reach the data You need within this three Years.
Is there any suggestion how to do this...
My thought is to dived tableBig in two... Table_1 that includes all data older than three Years and table_2 they rest. Table_2 is ofcourse the worktable where all new data is stored...
A query combines the table_2 with table_3 if You want to reach al data ....
But perhaeps ther is a better way ?
Is there any suggestion how to do this...
My thought is to dived tableBig in two... Table_1 that includes all data older than three Years and table_2 they rest. Table_2 is ofcourse the worktable where all new data is stored...
A query combines the table_2 with table_3 if You want to reach al data ....
But perhaeps ther is a better way ?