Skip to Content
0
Former Member
May 15, 2008 at 11:20 AM

Performance issue with RESB table

510 Views

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?