I'm working on a very large data base which is decreasing due to the large data contained on it Since 2006.
We have decided to keep our customer's data for the only the last 2 years.
I'm trying to run a script that delete all the purshaces's information closed before 2011.
The delete of data is extremely slow and i have more than 60Go of data to delete (there is any pdf or jpeg file on it)
To make it faster i tried to disable :
1) all the constraint FK
2) all the indexes
3) make the database on Simple Mode (disabling statistic,...)
My problem is that the script still too slow ....
Is there anybody who have a best solution to resolve this situation ?
Beside, i was wondering if it it's nos easier to copy my last 2 years data rather than deleting 5 years of data?
Thanks for your precious help