Skip to Content
0
Former Member
Jul 24, 2010 at 01:01 PM

problem with Delete quesry with performance issue

27 Views

HI All,

I have a problem with Delete query.

I have designed one Report, which will delete records from standard table.

The working of REport are as follows:-

1] I have moved the records to be deleetd in one internal table.

2] I have used delete syntax as "Delete Table from it_table".

But the problem is that there are around 1,50,000 records in internal table it_table.

so 1,50,000 will be deleted at a time. Hoe can i avoid this performance issue.

It would be good, if the code is sent throght forum.

Thnaks in Advance,