topic Re: Difference between select into table & select - endselect in Application Development and Automation Discussions

Difference between select into table & select - endselect

Former Member — Thu, 13 Mar 2008 09:42:17 GMT

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

which has good performance?

Re: Difference between select into table & select - endselect

Former Member — Thu, 13 Mar 2008 09:46:35 GMT

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

Re: Difference between select into table & select - endselect

Former Member — Thu, 13 Mar 2008 09:46:36 GMT

Hi,

check this thread

Regards,

Himanshu

Re: Difference between select into table & select - endselect

Former Member — Thu, 13 Mar 2008 09:47:00 GMT

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

Re: Difference between select into table & select - endselect

Former Member — Thu, 13 Mar 2008 09:47:16 GMT

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...

Re: Difference between select into table & select - endselect

Former Member — Thu, 13 Mar 2008 09:47:35 GMT

Hi,

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

Regards,

Mayank

Re: Difference between select into table & select - endselect

dhruv_shah3 — Thu, 13 Mar 2008 09:50:51 GMT

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

Re: Difference between select into table & select - endselect

Former Member — Thu, 13 Mar 2008 09:55:41 GMT

"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 !!