Regarding performance tuning

Former Member — Wed, 11 Oct 2006 10:25:40 GMT

Hi All,

Can any one please let me know whether SELECT ENDSELECT

is the worst in all the cases?

If it is worst in all the cases then when to use this?

Regards

Rakesh

Re: Regarding performance tuning

hymavathi_oruganti — Wed, 11 Oct 2006 10:28:41 GMT

we generally use select ........ endselect in the following case

exemple:

select field1 field2 from dbtab into itab.

itab-field3 = <some value not from dbtab>.

append itab.

endselect.

we use slect into table in the follwoing case:

select fiel1 field2 field3 from dbtab into table itab.