Hi experts,
I am having performance issue regarding this statement:
SELECT zfc_join~awb_id
APPENDING TABLE i_waybill_ids
FROM zfc_join INNER JOIN qmel
ON zfc_joinqmnum = qmelqmnum
FOR ALL ENTRIES IN r_vbeln_temp
WHERE qmart IN (c_dm,c_dv)
AND qmel~vbeln EQ r_vbeln_temp-low.
<b>*Additional Notes:</b>
1. QMEL contains 10 million+ records. ZFC_JOIN contains 200,000+ records.
2. Changed the range selection from QMEL~VBELN IN r_vbeln_temp to the codes above due
to a short dump error when the range is too big.
<b>Questions / clarification needed:</b>
1. Does the placement of the join tables matters? That is,
"zfc_join INNER JOIN qmel" is different from
"qmel INNER JOIN zfc_join"
2. Does the command "qmart IN (c_dv,c_dm)" different from
qmart EQ c_dv OR qmart EQ c_dm? Which is faster?
Please help out. Thanks