Dear All,
I have one Performance issue , my problem is the query given below
Takes much more time than Expected were i retreive data from resb table only by passing EBELN and WERKS .I am using key fields also still my performance is not increased so tell me how to increase performance .
SELECT rsnum
rspos
rsart
werks
baugr
ebeln
matnr
bdmng
enmng
lifnr
ebelp
ebele
INTO CORRESPONDING FIELDS OF TABLE it_disp
FROM resb
WHERE rsnum NE 0
AND rspos NE ''
AND rsart = rsart
AND werks = p_werks
AND ebeln = p_ebeln .
Thanks And Regards .
Deepak Dhamat .