topic Re: Performance Tuning in Application Development and Automation Discussions

Performance Tuning

Former Member — Tue, 03 Jun 2014 17:09:25 GMT

Hi ,

I've been told to use " SELECT INTO TABLE " rather than " SELECT INTO CORRESPONDING FIELDS OF TABLE " .

is it necessary ??? if YES !!!!???

then .... WHY SO !!!????

Kindly explain the concept behind the performance tuning ...

Thanks in Adv.

Bunty

Re: Performance Tuning

philipdavy — Tue, 03 Jun 2014 17:21:58 GMT

"SELECT INTO TABLE is better than 'INTO CORRESPONDING FIELDS OF' is a well established myth which is wrong.
There is an apt document for your reference written by Thomas Zloch in this regard.

Now about performance tuning, it is a very subjective term. You have to be more specific while asking about performance tuning. I would better give hints about some tcodes which you could make use while analyzing performance such as ST05, SAT etc. You should also not forget about the code checker you are having in SE38. In addition to it have a research on SLIN tcode as well.

Regards,

Philip.

Re: Performance Tuning

Former Member — Wed, 04 Jun 2014 02:58:45 GMT

Hi Bunty

SELECT INTO TABLE, the sequence of fields already fixed by the internal table define. Does not care about the field name or field type is same.

SELECT field1 field2 ...INTO CORRESPONDING FIELDS OF TABLE, Before push the data into internal table, system need compare the SQL select fields order one by one with the internal table define, then move the corresponding value to corresponding field of itab. This process must waste time.

So...

Regards,

Archer