2009 Dec 21 12:33 PM
<<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
2009 Dec 21 12:37 PM
The code is below, not above. For you, that is. For me, it is above, not below. Hope you understand.
Thomas
2009 Dec 21 3:03 PM
Looks like Subin is trying to divert attention and you just won the lotto..
2009 Dec 21 3:22 PM
You're right, looks like I got two tenners from Sandeep already...please contact me before taking action.
2009 Dec 22 3:53 PM
Hi Thomas,
Reading this was a real treat
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.
2009 Dec 22 4:02 PM
Yes, unfairness is often a horrible by-product of dishonest bias.
Subin's user ID will be deleted, along with his clones.
Cheers,
Julius
2009 Dec 22 4:10 PM
2009 Dec 22 4:13 PM
But you can still read the forum rules anyway, because Rob is still around...
Cheers and merry christmas,
Bluesky
