Hello experts,
I would like to find out if there are ways I can improve the performance of a select query in which there are no key fields in the WHERE clause. I have the following select statement from LIPS table and its quite slow:
IF gt_mchb[] IS NOT INITIAL.
SELECT matnr
werks
lgort
charg
lfimg
ntgew
FROM lips INTO TABLE gt_lips
FOR ALL ENTRIES IN gt_mchb
WHERE matnr = gt_mchb-matnr
AND werks = gt_mchb-werks
AND lgort = gt_mchb-lgort
AND charg = gt_mchb-charg
AND ntgew = gt_mchb-clabs.
ENDIF.
Thanks,
Mwela.