Skip to Content
0
Former Member
Aug 28, 2007 at 09:40 AM

SELECT WHERE IN issue

112 Views

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