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