Query tables - delete

[Former Member]

Hi,

Is there a way to quicken the speed of delete? currently, it takes 1 minute to delete 20 records.

statement :

delete from table_name where date > '20080210'?

currently, the table have 5 index key :

mandt, vbeln, posnr, status, username, date, time.

marks will be rewarded if relevant.

[Former Member]

Hi,

Because the "date" field is just a part of the primary key of the table this query will not use this index. One way to speed up the process is to define a secundary index (SE11) just on the date.

Regards,

John.

[Former Member]

Thanks John.