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.