Skip to Content
0
Former Member
Dec 04, 2008 at 05:59 AM

Rewrite SQL query to improve performance

103 Views

Hello,

The below queries are very time consuming.Could you please suggest how to improve performance for these 2 queries:

QUERY1:

SELECT avbeln aposnr aauart avkorg avtweg aspart

avkbur akunnr bmatnr bkwmeng b~vrkme

bnetwr bwerks blgort bvstel babgru berdat b~ernam

cfaksk cktext cvdatu czzbrsch ckvgr1 caugru

INTO CORRESPONDING FIELDS OF TABLE g_t_sodata

FROM vapma AS a INNER JOIN vbap AS b ON

avbeln = bvbeln AND aposnr = bposnr

INNER JOIN vbak AS c ON avbeln = cvbeln

WHERE a~vkorg IN so_vkorg

AND a~vtweg IN so_vtweg

AND a~vkbur IN so_vkbur

AND a~auart IN so_auart

AND a~vbeln IN so_vbeln

AND b~abgru IN so_abgru

AND c~faksk IN so_faksk

AND ( b~erdat GT g_f_zenkai_date OR

( berdat EQ g_f_zenkai_date AND berzet GE g_f_zenkai_time ) )

AND ( b~erdat LT g_f_kaisi_date OR

( berdat EQ g_f_kaisi_date AND berzet LT g_f_kaisi_time ) ).

QUERY2:

SELECT avbeln aposnr aauart avkorg avtweg aspart

avkbur akunnr bmatnr bkwmeng b~vrkme

b~netwr

bwerks blgort bvstel babgru berdat bernam

cfaksk cktext cvdatu czzbrsch ckvgr1 caugru

INTO CORRESPONDING FIELDS OF TABLE g_t_sodata

FROM vapma AS a INNER JOIN vbap AS b ON

avbeln = bvbeln AND aposnr = bposnr

INNER JOIN vbak AS c ON avbeln = cvbeln

WHERE a~vkorg IN so_vkorg

AND a~vtweg IN so_vtweg

AND a~vkbur IN so_vkbur

AND a~auart IN so_auart

AND a~vbeln IN so_vbeln

AND b~abgru IN so_abgru

AND c~faksk IN so_faksk.