What is the best practice to partition data from a very large table?
Posted on 2005-04-25
We have a very large table with millions of rows. We would like to partition the data based on the canlendar year. What is the best practice and the most efficient way to partition (to archive) those old data into the new partition? Is creating a new database the way to go? If not, could someone shed some lights on this for us?