re field order in INNER JOIN

Hi,

I need a suggestion for improvement of my inner JOIN statement.

internal table itab is of below type

type: begin of ty_itab

field a

field b

field c

field d

end of ty_itab

I have to join two database table TABLE1 and TABLE2. Fields a and d are from TABLE2 and fields b and c are from TABLE 1.

But in the internal table I must have the fields in the order fielda,b,c,d.

Which of the below two options will be better for performance ? And why ?

option 1:

SELECT tab2~a

tab1~b

tab1~c

tab2~d into corresponding fields of itab from TABLE1 as tab1 and TABLE2 as tab2 on..........

option2:

SELECT tab1~b

tab1~c

tab2~a

tab2~d into corresponding fields of itab from TABLE1 as tab1 and TABLE2 as tab2 on..........

Thanks in advance...

Best Regards

Ananya Mukherjee

Moderator message - Cross post locked

Edited by: Rob Burbank on May 28, 2009 9:43 AM