Select Statement

<b>select...endselect</b>, does not fetch all records at one stretch, whereas in the other case, it does fetch all the records at one stretch.

So what ?

Suppose to fetch a record, time taken is X, if there are 100 records it will take 100*X seconds. In the select into table, this is not the case. It will take much lesser time.

<i>Go to SE38, in the menu select Environment, then select Performance Examples. Choose the Select ..Into Table example and measure the difference.</i>

Regards,

Subramanian V.

Message was edited by: Subramanian Venkateswaran

When you write Select ... into Table itab the selection makes one query from database,

however select .... endselect , queries the same statement as much as the records found.

So there is more network load, more database load and slower program.

-

Please give points if it helps.