topic Difference between package size 1 and select single in Application Development and Automation Discussions

Difference between package size 1 and select single

Former Member — Thu, 23 Jul 2009 09:10:57 GMT

Hi,

Can anybody tell me the difference between package size 1 and select single?

which is to be used in what situation?

Thanks

Parag

Former Member — Thu, 23 Jul 2009 09:14:29 GMT

Hi,

Package size 1 means: 1 record(s) at a time selected form DB table.

Select *

from kna1

into itab package size1.

endselect.

If u r KNA1 table contain 50 recors, then this select will execute 50 times and get 1 record each time...

Kiran

Edited by: kiran vempati on Jul 23, 2009 2:44 PM

Former Member — Thu, 23 Jul 2009 12:26:27 GMT

Hi Parag Gavkar,

use SELECT SINGLE if your query should return only 1 record.

Due to performance issues the where-clause should be well defined.

Please refer to F1 Help, your issue is well documented.

regards

REA

Former Member — Thu, 23 Jul 2009 14:40:24 GMT

Hi,

check the below code

when we are using packet size 1 it is executing for all the records in the database i.e it is executing like loop.....endloop

SELECT *

FROM scarr

INNER JOIN spfli ON scarr_{carrid = spfli}carrid

INTO TABLE itab PACKAGE SIZE 1.

endselect.

where as select single * will execute only once based on where condition.

Thanks & Regards,

Sateesh.