topic Re: Query tables - delete in Application Development and Automation Discussions

Query tables - delete

Former Member — Wed, 27 Feb 2008 08:48:24 GMT

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.

Re: Query tables - delete

Former Member — Wed, 27 Feb 2008 09:05:20 GMT

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.

Re: Query tables - delete

Former Member — Wed, 27 Feb 2008 09:44:52 GMT

Thanks John.