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.