Skip to Content
0
May 06, 2010 at 11:37 AM

Performance improvement in select query

37 Views

Hi,

I have to improve the performance of the one custome program. I applied SQL trace & found out that below extract of code is taking maximum time.

SELECT vbak~vbeln

vbak~erdat

vbak~auart

vbak~augru

vbak~vkorg

vbak~vtweg

vbak~spart

vbak~kunnr

vbak~submi

vbak~knumv

vbuk~fksak

INTO CORRESPONDING FIELDS OF TABLE it_vbak

FROM vbak

INNER JOIN vbuk ON vbakvbeln EQ vbukvbeln

WHERE vbak~vbeln IN s_vbeln

AND vbak~vkorg EQ p_vkorg

AND vbak~vtweg EQ p_vtweg

AND vbak~spart IN s_spart

AND vbak~erdat IN s_erdat

AND vbak~kunnr IN s_kunnr

AND vbak~auart IN r_auart

AND vbak~augru EQ c_zcb

AND vbuk~fksak EQ c_c.

How can i use the for all entries in above code.. Will it enhance the performance of the code?