1 Reply Latest reply: Jun 3, 2009 8:29 AM by Lars Breddemann RSS

deleting table contents via SQL painfully slow

Gary Vaughan
Currently Being Moderated



We are running SAP ECC on SUSE 9 Linux with Maxdb 7.6.6 - and

for the most part performance is not an issue.


I am trying to do a remote client copy which I am having problems with. It is taking forever to do the table coss .


in the target - the table has approxiametly 5,000,000 rows in the database, while the client target has at least 2,000,000+ rows.


By my rough calculations if I let the client copy do the delete ( before the insert ) it will take at least another two days just to delete the data.


I have tried to delete the contents directly via dbmcli as below


dbmcli on dec>sql_execute delete from sapdec.coss where mandt = '122'


but the session just times out after 60 minutes ( another issue ).



I am starting to look around the database but cannot see anything obivous.


Any suggestions of where to look would be greatly appreciated.


Thanks in advance