Difference between select into table & select - endselect

[Former Member]

What is the difference between select into table & select - endselect?

which has good performance?

[Former Member]

Hi,

There is no diff between select ... end select and select into table. both r same. performance wise select into table is best.

Regards,

S.nehru

[Former Member]

Hi,

check this thread

Regards,

Himanshu

[Former Member]

Select up to 1 rows has better performance as compared to select single in case all key fields are not there in WHERE clause.

[Former Member]

Hi,

SELECT INTO TABLE : Here all the data will be fetched atonce in internal table.So connecting the database for data is once.

SELECt .....END SELECT. It is just like loop.

Each time request will go to the database So connections to database are more.So performance of the program will get reduce...

[Former Member]

Hi,

Select into table is better since it hits the database only once, while select endselect keeps hitting till the records exhausts.

Regards,

Mayank

[dhruv_shah3]

Hi,

If you use the select into table from some table for all entries,

then its better for performance,whereas the select..endselect itself is a one type of loop.

So its better to select into table.

HTH

Regards,

Dhruv Shah

[Former Member]

"Select into table" will fetch the entire data marked by query into the internal table.It is generally used data retrival.

But in some case the data requires to be modifed or manipulated before being place into internal table.In such a case we use "select - endselect".This allow to manipulate each row selected by the query in desired manner.

hope this answer your question !!