Skip to Content
0
Former Member
Nov 24, 2008 at 06:01 PM

Performance issues with inner joins...

61 Views

Hi,

I have a query which needs to be performance tuned... Its taking long to execute in background. Please see if we can tune this query by any chance..

select vbakkunnr vbakvbeln vbapposnr vbakvdatu vbak~bstnk

vbaknetwr kna1stras kna1ort01 kna1regio kna1~pstlz

vbakvkbur vbapmatnr vbaparktx vbapkwmeng

vbapnetpr vbapnetwr

into table i_order

from vbak

inner join vbpa on vbpavbeln eq vbakvbeln

inner join kna1 on kna1kunnr eq vbpakunnr

inner join vbap on vbapvbeln eq vbakvbeln

inner join vbup on vbupvbeln eq vbapvbeln

and vbupposnr eq vbapposnr

inner join vbep on vbepvbeln eq vbupvbeln

and vbepposnr eq vbupposnr

where vbak~auart in r_auart

and vbak~kunnr in r_kunnr

and vbak~vkbur in r_vkbur

and vbpa~parvw eq 'WE'

and vbap~kwmeng gt 0

and vbap~abgru eq space

and vbep~bmeng gt 0

and vbup~lfsta ne c_completely_processed.

Thanks,

Vinod.