Row by row update

[Former Member]

<<stop posting your interview questions>>

Hi

The below select statement is taking too much time in Production system,

is there any way to optimize the above code ?

"select * from VVBAP

into g_wa_vvbap

where vbeln in g_vbeln.

g_wa_vvbap-zmeng = g_wa_vvbap-zmeng + 5.

update vvbap from g_wa_vvbap.

Endselect."

Sandeep

Edited by: Matt on Dec 21, 2009 2:10 PM

[Former Member]

<<stop posting your interview questions>>

Hi

The below select statement is taking too much time in Production system,

is there any way to optimize the above code ?

"select * from VVBAP

into g_wa_vvbap

where vbeln in g_vbeln.

g_wa_vvbap-zmeng = g_wa_vvbap-zmeng + 5.

update vvbap from g_wa_vvbap.

Endselect."

Sandeep

Edited by: Matt on Dec 21, 2009 2:10 PM

[ThomasZloch]

The code is below, not above. For you, that is. For me, it is above, not below. Hope you understand.

Thomas

[Former Member]

Looks like Subin is trying to divert attention and you just won the lotto..

[ThomasZloch]

You're right, looks like I got two tenners from Sandeep already...please contact me before taking action.

Thomas

[Former Member]

Hi Thomas,

Reading this was a real treat

The code is below, not above. For you, that is. For me, it is above, not below. Hope you understand.

My experience ..

I searched for the answer so that i may be the early bird to post the answer,on this thread..and win some good points on this thread...

I felt bad that day that in spite of my efforts, Sandeep gave 10 points to Subin.

Now i see it all

Am feeling a looooooooooottttttttt better now.

Sandeep,Subin,Vicky... lesson to be learnt

Regards,

SuryaD.

[Former Member]

Yes, unfairness is often a horrible by-product of dishonest bias.

Subin's user ID will be deleted, along with his clones.

Cheers,

Julius

[Former Member]

Regards,

SuryaD.

[Former Member]

But you can still read the forum rules anyway, because Rob is still around...

Cheers and merry christmas,

Julius