Deletion of 10 million records from a table

[jyothsna T]

In a table I have 40 million records out of which I need to delete around 10 million records every year. We use Load replace technique for this. But it consumes lot of time. Is there any possibility by using Reorg/Discard Utility or by using SQL query for deleting the records (In intervals, each time around 1 Lakh records) can we reduce the CPU time and increase the performance of the deletion activity?

[Rabbit]

DELETE FROM tableName
WHERE <criteria that defines the records to delete>

[Luuk]

You could use something like partitioning on that table

read more about that here:

http://www.ibm.com/developerworks/data/library/techarticle/dm-0605ahuja2/