Hi
i have written sql like this, program is running for hour, andw heni run se30 it showed the program is taking lion's share of runtime. how to tune this statement?
SELECT vbeln
wadat
FROM likp
INTO TABLE t_likp
FOR ALL ENTRIES IN t_vbak
WHERE vkorg = t_vbak-vkorg
AND kunag = t_vbak-kunnr
AND wadat_ist IN so_budat.