Here is one solution:
>> export the table without the data you want to delete using where clause
>>import an empty file in the table; this is the fastest way to delete data from table without using much of log activity
>>load the file exported in first step which will contain only the data you wanted to keep
You can automate this whole process to better use it.
Hope this helps
dollar
Quote:
Originally posted by David2002
Thank you for your answer , Yes I did runstats and bound the packages.
I imagin if we have a table with 200 mil records (that I will have in future in our system) what is the best solution for deletition a part of table.
Thank you in advanace for your co-operation
|