Performance Tuning

[Former Member]

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

[philipdavy]

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

[Former Member]

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