Large Table Partition
Hi,
While doing partition for large table(more then 1 TB) what kind of precaution need to take?
And we are containing two year data in table and trying do RANG partition based on date column. However i have one doubt, from table each month we will delete one month data e.g. let assume we have data since 1-Jan-2015 to 31-Dec-2016. Now if we insert data for Jan 2017 month then Jan 2015 data will be archived. For this how we can approach for partition.
Thanks,
Br