08-06-2007 6:42 PM
My code below is taking too much time around 13,369,415
I need to improve the performance of the code. any ideas!!!
SELECT SINGLE aufnr
FROM mseg
INTO v_aufnr
WHERE charg IN charg
AND bwart = v_move.
08-06-2007 7:00 PM
Hi.
The use of IN kill performance. Try to select without IN.
Regards.
08-06-2007 7:08 PM
I tried without
IN
and its the same performace. It has to do with
MSEG
table, I think the table has a lot of data and too many fields.
08-06-2007 7:47 PM