Mass update a field in Z*table

[ricky_shaw]

Hi,
I need to mass update a field in a Z*table that has 20Millions entries.

I am using UPDATE Z*table set + COMMIT WORK while looping in an itab.

I scheduled it as background job which is taking like 6-8 hrs..

Is there any way to make this more faster?

[nomssi]

• Select disctint data packages and run the processing in parallel
• Do not COMMIT at each step of the loop, but in packages of predefined size (You might have to update the error handling)

[Sandra_Rossi]

To reduce the amount in memory and update only few fields, see this thread, Solved: Re: What is the best way to mass update "Custom fi... - SAP Community, and also the discussion around the drawbacks by Mike.

You have to check what is slow: run a trace, check the execution plan. Currently, you just say that it's "slow", but we are blind for the rest. Also, you may update in parallel (possibly via ABAP, or via database hints).

[ricky_shaw]

Hi Nomssi, Can you please help me with an example for "Selecting distinct data packages ".

I am already scheduling this as job submits with 50 threads.

[nomssi]

I mean, your 50 jobs should not process the same data set. As Sandra said, we are blind here. 

Best regards

JNN