Skip to Content

Selective Deletion in DSO is taking lot of time

Hi,

Selective Deletion in DSO is taking a lot of time to complete.On 19th when the Program ran for 166 million records it took 7 hrs to complete whereas when the program ran on 20th for 320 million records it took only 45 mins to complete.The difference that I observed between the job logs was that on the 20th,the index deletion took place before the records got deleted selectively through the program and the index deletion did not take place on the 19th.What could be the reason behind this? Both the times the same standard program was executed through the process chain and there were no other processes running when the selective deletion step was running.

There are no secondary indexes created on the DSO.

Regards,

Shalaka

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    May 27, 2015 at 12:26 PM

    I have resolved the issue by myself.

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2015 at 06:16 AM

    Hi Shalaka,

    Below sap note gives you an idea how this selective deletion works.

    792435 - Selective deletion: Using temporary tables

    Regards,

    Vengal.

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2015 at 06:01 AM

    Also please note that on 19th the data got deleted in chunks of 100000 records whereas on the 20th the records got deleted in one go.What could be the reason behind this?

    Add comment
    10|10000 characters needed characters exceeded