Skip to Content
0
Former Member
Jun 24, 2010 at 06:57 AM

Performance of select query with inner join and for all entries

447 Views

Hi Experts,

Please suggest me about the performance of the following select query. Its taking more time when i have checked in st05.



SELECT a~shpmnum_ob b~capa_fixed
      FROM /lot/pl_tour_h AS a
      INNER JOIN /lot/vo_lara_st AS b
      ON b~losp_id EQ a~res_losp_id
      INTO TABLE l_i_truck1
      FOR ALL ENTRIES IN l_i_shipment1
      WHERE a~shpmnum_ob EQ l_i_shipment1-tknum
        AND b~uom        EQ c_pal.


Thanks in advance

G.S.Naidu