Skip to Content
0
Former Member
Oct 10, 2006 at 09:53 AM

VBFA performance issue

386 Views

SELECT vbfa~vbelv

vbfa~vbeln

vbak~auart

INTO TABLE t_s751

FROM vbfa

INNER JOIN vbak

ON vbfavbelv = vbakvbeln

FOR ALL entries IN gc_s751

WHERE vbfa~vbeln = gc_s751-vbeln.

The above select query is taking 7 min time in Quality

Server. The number of values in gc_s751 table are around 2000. And this may take more time in Production server.

So kindly let me know what steps to be taken to reduce

the time.