Skip to Content
0
Former Member
Jan 05, 2012 at 09:45 AM

Select query from lips table too slow

428 Views

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.