Reduce the table size

[Ray]

I have a table having more than 10 years records. How can I move some old
records to other table to improve performance. In case I need to search the
historical records, do I need merge old and new tables into one. Any other
idea is appreciated.

Thanks,

Ray

 

[Guest]

Although there are many ways to get rid of the old records, the quickest in
most cases, is to make a copy of the original table, then go into it and
delete what you don't want. You can select multiple ranges witht the shift
key, or use ctrl to select out-of-range records (like you would do in Windows
Explorer).

As for accessing that data, could you make a routine like you already to
view the current records, simply access the "old data" table? Yes you can
merge them back if needed, as long as index doesn't renumber them

 

[Ray]

Bill,

Thanks for your useful advice. Regarding that index doesn't renumber them,
how can I prevent it after I remove the old records. It may also prevent
the merge if it is needed.

Ray