client import SCC7 take a long time to delete BSEG Cluster table

[Former Member]

Dear All,

We are doing client copy through EXPORT/IMPORT method, During Import Post Process using SCC7 BSEG table take long time to delete ( it contain around 15342331 records during one day it delete 2057344 records ) what is the best solution that can speed up our import process .

NOTE :- We can not delete existing client ( for example our exist client is 888 and we are overwrite that client not delete it )

Regards

Shahid

[Former Member]

unanswered

[Former Member]

Hi Shahid,

Please check the indexes and if necessary, run the index re-build for these.

After that please run the update statistics for this table.

Also, please note that BSEG is a very large table in the SAP system and hence will take some time to copy.

Hope this helps.

Regards,

Hari Kishan

[Former Member]

Hi,

If it is Oracle, try running update statitics on this table.

Regards,