Package size

Former Member — Thu, 08 Jan 2009 13:06:40 GMT

Hi,

Guide me which select is faster and how???

(I) SELECT a~matnr

b~b_werk

b~b_lager

a~equnr

b~b_charge

b~lbbsa

INTO CORRESPONDING FIELDS OF TABLE it_esn PACKAGE SIZE 40000

FROM equi AS a INNER JOIN eqbs AS b

ON a_{equnr = b}equnr

WHERE a~matnr IN s_matnr

AND b~b_werk IN s_werks

AND b~lbbsa IN ('01','07','03').

Processing contain some other select statements using for all entries from the above statement.

endselect.

(II) SELECT a~matnr

b~b_werk

b~b_lager

a~equnr

b~b_charge

b~lbbsa

INTO CORRESPONDING FIELDS OF TABLE it_esn

FROM equi AS a INNER JOIN eqbs AS b

ON a_{equnr = b}equnr

WHERE a~matnr IN s_matnr

AND b~b_werk IN s_werks

AND b~lbbsa IN ('01','07','03').

Processing contain some other select statements using for all entries from the above statement.

Edited by: Ram Ram on Jan 8, 2009 2:20 PM

Re: Package size

Former Member — Thu, 08 Jan 2009 15:29:32 GMT

you are missing the point!

Package siue only makes sense if there is another processing afterwards, which should not process large numbers of records.

And in your question, nobody can see whether the select will find at least 4000 records, if not then they are identical !

Siegfried