Hi,
User want to improve the performance of a standard program RLLL07SE in which a RESB table data is fetched and take much time on it.
The select querry for RESB is,
SELECT * FROM RESB WHERE
MATNR = MATNR AND
WERKS = WERKS AND
XLOEK = SPACE AND "Löschkennzeichen
KZEAR = SPACE AND "endausgefaßt
XWAOK = CON_X AND "Warenausgang erlaubt
LGNUM = LGNUM AND
LGTYP = LGTYP AND
LGPLA = LGPLA.
whereas the table index is created on following fields of RESB,
MATNR
WERKS
XLOEK
KZEAR
BDTER
What possible can be done in this respect as the program is a standard one we can change only in Table Inxex I guess..or what else can be done?
Can we add LGNUM LGTYP LGPLA into the particular index apart from the existing fields?